2.204 RMTTRAIL

Valid for

Extract

Description

Use RMTTRAIL to establish the current remote trail on a remote system connected by TCP/IP. All FILE and TABLE entries after the current entry but before the next Extract file parameter (EXTFILE, EXTTRAIL, RMTBATCH, RMTFILE, RMTTRAIL) result in output to the current trail.

The remote trail must correspond with a RMTTRAIL entry created with GGSCI. The Extract group in the parameter file must match the Extract entry linked with the RMTTRAIL. For more information about adding remote Oracle GoldenGate trails, refer to"ADD RMTTRAIL".

Syntax

RMTTRAIL file_[, FORMAT RELEASE major.minor] prefix

FORMAT RELEASE major.minor

Specifies the trail format of the data that is sent by Extract to a trail, file, or (if a remote task). The value tells the reader process whether the data records are of a version that it supports. The format depends on the version of the Oracle GoldenGate process. Newer Oracle GoldenGate versions contain different characteristic than older ones.

  • FORMAT is a required keyword.

  • RELEASE specifies an Oracle GoldenGate release version. major is the major version number, and minor is the minor version number. The X.x must reflect a current or earlier, generally available (GA) release of Oracle GoldenGate. Valid values are 9.0 through the current Oracle GoldenGate X.x version number, for example 11.2 or 12.1. (If you use an Oracle GoldenGate version that is earlier than 9.0, specify either 9.0 or 9.5.). The release version is programmatically mapped back to an appropriate internal compatibility level. The default is the current version of the process that writes to this trail.

file_prefix

The path name of the remote file. A six character sequence indicator is added to each file in the remote trail to make up individual file names.

Remote Oracle GoldenGate trails are used over TCP/IP connections only. Do not specify an Expand node name in the file_prefix, even if the remote system is also connected with Expand. To specify a trail on a different NonStop node over an Expand connection, use the EXTFILE or EXTTRAIL parameters.

Example

The following example assumes that an Extract group FINANCE was established with GGSCI. The example also assumes that two remote Oracle GoldenGate trails were created in GGSCI and associated with EXTRACT FINANCE. This configuration sends ACCOUNTS records to the XX trail, and ORDERS to the YY trail. The parameter file includes the following commands:

EXTRACT FINANCE
RMTHOST 192.0.2.2, MGRPORT 7809
RMTTRAIL /ggs/dirdat/XX 
FILE $DATA2.FINANCE.ACCOUNTS;
RMTTRAIL /ggs/dirdat/YY 
FILE $DATA3.FINANCE.ORDERS;