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 2 Extract Parameters: General

Parameter	Description
`ABORTDISCARDRECS`	Controls the number of discarded records after which Extract aborts.
`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 3 Extract Parameters: Processing Method

Parameter	Description
`EXTRACT`	Defines an Extract group as an online process.
`SOURCEISTABLE`	Extracts entire records from source tables.

Table 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 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.

Table 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.
`TRANLOGOPTIONS`	Supplies capture processing options.
`WARNLONGTRANS`	Defines a long-running transaction and controls the frequency of checking for and reporting them.

Table 7 Extract Parameters: Maintenance

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

Table 8 Extract Parameters: Security

Parameter	Description
`DECRYPTTRAIL`	Required to decrypt data on the target server.
`ENCRYPTTRAIL \\| NOENCRYPTTRAIL`	Controls encryption of data in a trail or Extract file.