Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

The correct answer is D. SEND EXTRACT <group>, ROLLOVER. In reference guide, page 36:Syntax SEND EXTRACT <group name>, {CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS <ID> [THREAD <n>] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER |SHOWTRANS [<ID>] [THREAD <n>] [COUNT <n>][DURATION <duration><unit>]…

Troubleshooting and Monitoring

Question

Options

AALTER EXTTRAIL <trail name>, NEXTSEQNO
BALTER EXTTRAIL <trail name>, ROLLOVER
CSEND EXTRACT <group>, ETROLLOVER
DSEND EXTRACT <group>, ROLLOVER

How the community answered

(35 responses)

A
9% (3)
B
3% (1)
C
17% (6)
D
71% (25)

Explanation

In reference guide, page 36:Syntax SEND EXTRACT <group name>, {CACHEMGR {CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS <ID> [THREAD <n>] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER |SHOWTRANS [<ID>] [THREAD <n>] [COUNT <n>][DURATION <duration><unit>] [TABULAR][FILE <name> [DETAIL]] |SKIPTRANS <ID> [THREAD <n>] [FORCE]STATUS |STOP |TLTRACE {DEBUG | OFF | <level>} [DDLINCLUDE | DDL[ONLY]] [FILE] <file name> |TRACE[2] <tracefile> |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS {PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS} |TRANLOGOPTIONS TRANSCLEANUPFREQUENCY <minutes> |VAMMESSAGE "<Teradata command>" |VAMMESSAGE {"ARSTATS" | "INCLUDELIST [filter]" | "EXCLUDELIST [filter]"} |VAMMESSAGE "OPENTRANS"}

Topics

#SEND EXTRACT#trail rollover#trail sequence#extract commands

Community Discussion

No community discussion yet for this question.

Full 1Z0-481 Practice