Summary of Extract Parameters

The Extract process captures either full data records or transactional data changes, depending on configuration parameters, and then sends the data to a target system to be applied to target tables or processed further by another process, such as a load utility.

Table 1-2 Extract Parameters: General

Parameter	Description
`ABORTDISCARDRECS`	Controls the number of discarded records after which Extract aborts.
`SOURCEDB`	Specifies the data source as part of the login information.
`TCPSOURCETIMER \| NOTCPSOURCETIMER`	Adjusts timestamps of records transferred to other systems when those systems reflect different times.
`UPDATERECORDFORMAT`	Controls whether before and after images are stored in one trail record or two.

Table 1-3 Extract Parameters: Processing Method

Parameter	Description
`EXTRACT`	Defines an Extract group as an online process.
`GETAPPLOPS \| IGNOREAPPLOPS`	Controls whether or not operations from all processes except Replicat are written to a trail or file.
`GETREPLICATES \| IGNOREREPLICATES`	Controls whether or not replicated operations are captured by an Extract on the same system.
`SOURCEISTABLE`	Extracts entire records from source tables.

Table 1-4 Extract Parameters: Selecting, Converting, and Mapping Data

Parameter	Description
`COMPRESSDELETES \| NOCOMPRESSDELETES`	Controls whether Oracle GoldenGate writes only the key or all columns to the trail for delete operations.
`COMPRESSUPDATES \| NOCOMPRESSUPDATES`	Causes only primary key columns and changed columns to be logged for updates.
`EXCLUDEHIDDENCOLUMNS`	The parameter disables all the Oracle Database hidden columns including the timestamp columns created using automatic CDR.
`EXCLUDETAG`	Specifies Replicat or data pump changes to be excluded from trail files.
`FETCHOPTIONS`	Controls certain aspects of the way that Oracle GoldenGate fetches data.
`LOGALLSUPCOLS`	Logs the columns that are required to support Conflict Detection and Resolution and Integrated Replicat.
`SEQUENCE`	Specifies sequences for synchronization.
`TABLE \| MAP`	Specifies tables for extraction and controls column mapping and conversion.
`TABLEEXCLUDE`	Excludes source tables from the extraction process.
`TARGETDEFS`	Specifies a file containing target table definitions for target databases that reside on the NonStop platform.
`TRAILCHARSETASCII`	Specifies the ASCII character set for data captured from DB2 on z/OS, when both ASCII and EBCDIC tables are present.
`TRAILCHARSETEBCDIC`	Specifies the EBCDIC character set for data captured from DB2 on z/OS, when both ASCII and EBCDIC tables are present.

Table 1-5 Extract Parameters: Routing Data

Parameter	Description
`EXTFILE`	Specifies an extract file to which extracted data is written on the local system.
`EXTTRAIL`	Specifies a trail to which extracted data is written on the local system.
`RMTFILE`	Specifies an extract file to which extracted data is written on a remote system.
`RMTHOST`	Specifies the target system and Manager port number.
`RMTTRAIL`	Specifies a trail to which extracted data is written on a remote system.

Table 1-6 Extract Parameters: Tuning

Parameter	Description
`BR`	Controls the Bounded Recovery feature of Extract.
`CACHEMGR`	Controls the virtual memory cache manager.
`FLUSHSECS \| FLUSHCSECS`	Determines the amount of time that record data remains buffered before being written to the trail.
`RMTHOSTOPTIONS`	Specifies connection attributes other than host information for a TCP/IP connection used by a passive Extract group.
`TRANLOGOPTIONS`	Supplies capture processing options.
`WARNLONGTRANS`	Defines a long-running transaction and controls the frequency of checking for and reporting them.

Table 1-7 Extract Parameters: Maintenance

Parameter	Description
`ROLLOVER`	Specifies the way that trail files are aged.

Table 1-8 Extract Parameters: Security

Parameter	Description
`DECRYPTTRAIL`	Required to decrypt data when Extract is used as a data pump and must do work on the data.
`ENCRYPTTRAIL \| NOENCRYPTTRAIL`	Controls encryption of data in a trail or extract file.