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
Thanks in advance
CREATE SET TABLE dbp_etl_log.frprg_t16e3a6294b63ea1fb21_L ,FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
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',
TOTALAMPS SMALLINT DEFAULT 0 ,
UPAMPS SMALLINT DEFAULT 0 ,
DOWNAMPS SMALLINT DEFAULT 0 ,
UNIQUE PRIMARY INDEX ( LOGTYPE ,OPERSEQ );
Hello TD TPT experts/connoisseurs:
it would be posible for someone of you to give a comment on my question above?
Thanks in advance!
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.
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).