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

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

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

A.
ALTER EXTTRAIL <trail name>, NEXTSEQNO

B.
ALTER EXTTRAIL <trail name>, ROLLOVER

C.
SEND EXTRACT <group>, ETROLLOVER

D.
SEND EXTRACT <group>, ROLLOVER

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”}



Leave a Reply 1

Your email address will not be published. Required fields are marked *


marco procida

marco procida

In the reference guide for 11g is page 38