TPT Work/error Tables always protected (FALLBACK) ?

Tools & Utilities
Enthusiast

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

6 REPLIES
Highlighted
Enthusiast

Re: TPT Work/error Tables always protected (FALLBACK) ?

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

Enthusiast

Re: TPT Work/error Tables always protected (FALLBACK) ?

Hello TD TPT experts/connoisseurs:

it would be posible for someone of you to give a comment on my question above?

Thanks in advance!

Enthusiast

Re: TPT Work/error Tables always protected (FALLBACK) ?

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
Enthusiast

Re: TPT Work/error Tables always protected (FALLBACK) ?

Thank you, but your contribution does not help me.

Reques for a response from a TPT specialist.

Thanks

Teradata Employee

Re: TPT Work/error Tables always protected (FALLBACK) ?

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
Enthusiast

Re: TPT Work/error Tables always protected (FALLBACK) ?

Thank you for your prof. answer