All Forums Tools
stami27 11 posts Joined 06/09
21 Jun 2016
TPT Work/error Tables always protected (FALLBACK) ?

Hi,
can anyone tell me if I can affect on tptstream
that the work or error  tables could be created as NO FALLBACK?
Currently in the version tptstream1500 (15.00.00.04-1)
the work tables are always created as FALLBACK.
We run with TD 15.00 and tptstream1500-15.00.00.04-1
see image
Thanks in advance

stami27 11 posts Joined 06/09
21 Jun 2016
CREATE SET TABLE dbp_etl_log.frprg_t16e3a6294b63ea1fb21_L ,FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      LOGTYPE INTEGER,
      OPERSEQ INTEGER DEFAULT 0 ,
      RUNDATE DATE FORMAT 'YYYY/MM/DD' DEFAULT DATE ,
      RUNTIME FLOAT FORMAT '99:99:99' DEFAULT TIME ,
      USERID CHAR(128) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL DEFAULT USER ,
      LOGVERSION CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC DEFAULT 'V3.0',
      CHKPTINFO VARBYTE(100),
      TOTALAMPS SMALLINT DEFAULT 0 ,
      UPAMPS SMALLINT DEFAULT 0 ,
      DOWNAMPS SMALLINT DEFAULT 0 ,
      AMPARRAY VARBYTE(24576))
UNIQUE PRIMARY INDEX ( LOGTYPE ,OPERSEQ );

example
 
 

stami27 11 posts Joined 06/09
22 Jun 2016

Hello TD TPT experts/connoisseurs:
it would be posible for someone of you to give a comment on my question above?
Thanks in advance!

M.Saeed Khurram 544 posts Joined 09/12
22 Jun 2016

Hi,
I think you need to contact Customer Support, there is a global paramter for tables to be fallback or not fallback. But you will have to consider lot of things before disabling this option.
Br,
Khurram

Khurram

stami27 11 posts Joined 06/09
22 Jun 2016

Thank you, but your contribution does not help me.
Reques for a response from a TPT specialist.
Thanks

feinholz 1234 posts Joined 05/08
22 Jun 2016

The error tables are created as FALLBACK for the protection of the user so that the jobs can run in the event of a down AMP in a cluster.
Right now there is no way for the user to indicate to us that they would like the error table to be created as non-FALLBACK (with the user knowing the dangers of doing so).
 
 

--SteveF

stami27 11 posts Joined 06/09
23 Jun 2016

Thank you for your prof. answer

You must sign in to leave a comment.