ADD EXTTRAIL
Create a trail for
* Online processing on the local system
* Associate it with an Extract group
* Assign a maximum file size
Syntax
ADD EXTTRAIL <trail name>, -- Full path name of trail name (two characters only) EXTRACT <GROUP name> -- Only one extract can write data to trail [, MEGABYTES n] -- Max size of trail file
Examples
GGSCI 57> add exttrail ./dirdat/cu, extract e_cust, megabytes 20 EXTTRAIL added.
ALTER EXTTRAIL
Alter local extract trail attributes. The change takes effect the next time extract starts.
Syntax
ALTER EXTTRAIL <trail name>, EXTRACT < GROUP name>[, MEGABYTES <n>]
Examples
GGSCI 12> info exttrail * EXTRACT Trail: ./dirdat/cu EXTRACT: E_CUST Seqno: 0 RBA: 0 File SIZE: 20M EXTRACT Trail: C:\prog\GoldenGate\GoldenGate_Src\dirdat\cu EXTRACT: E_CUST Seqno: 0 RBA: 980 File SIZE: 20M GGSCI 13> ALTER exttrail C:\prog\GoldenGate\GoldenGate_Src\dirdat\cu, EXTRACT e_cust, megabytes 25 EXTTRAIL altered. GGSCI 14> info exttrail * EXTRACT Trail: ./dirdat/cu EXTRACT: E_CUST Seqno: 0 RBA: 0 File SIZE: 20M EXTRACT Trail: C:\prog\GoldenGate\GoldenGate_Src\dirdat\cu EXTRACT: E_CUST Seqno: 0 RBA: 980 File SIZE: 25M
ALTER RMTTRAIL
Change extract trail attributes on a remote system. The change takes effect the next time extract starts.
Syntax
ALTER RMTTRAIL <trail name>, EXTRACT <GROUP name> [, MEGABYTES <n>]
Examples
ALTER RMTTRAIL c:\ggs\dirdat\aa, EXTRACT finance, MEGABYTES 20
DELETE EXTTRAIL
Delete checkpoint records associated with a trail on local system. Does not delete trail files themselves. Use standard OS commands to remove files.
Syntax
DELETE EXTTRAIL <trail name>
Examples
DELETE EXTTRAIL /home/ggs/dirdat/et
DELETE RMTTRAIL
Delete checkpoint records associated with a trail on remote system. Does not delete trail files themselves. Use standard OS commands to remove files.
Syntax
DELETE RMTTRAIL <trail name>
Examples
DELETE RMTTRAIL /home/ggs/dirdat/et
INFO EXTTRAIL
Retrieves extract trail info for a local trail.
Syntax
INFO EXTTRAIL <trail name>
Examples
GGSCI 18> info exttrail ./dirdat/cu EXTRACT Trail: ./dirdat/cu EXTRACT: E_CUST Seqno: 0 RBA: 0 File SIZE: 20M GGSCI 19> info exttrail *
INFO RMTTRAIL
Get extract trail info on a remote system.
Syntax
INFO RMTTRAIL <trail name>
Examples
INFO RMTTRAIL c:\ggs\dirdat\aa
INFO RMTTRAIL *