EOFDELAY | EOFDELAYCSECS

Valid For

Extract and Replicat

Description

Use the EOFDELAY or EOFDELAYCSECS parameter to control how often Extract or Replicat checks for new data after it has reached the end of the current data in its data source. You can reduce the system I/O overhead of these reads by increasing the value of this parameter.

Note: Large increases can increase the latency of the target data, especially when the activity on the source database is low

This parameter is not valid when SOURCEISTABLE is used. This parameter cannot be set to zero (0).

Default

The default setting for EOFDELAY is 1 second (which equates to EOFDELAYCSECS 100).

The maximum value for EOFDELAY can be set to 60 seconds (which equates to EOFDELAYSECS 6000).

The acceptable minimum setting for EOFDELAYCSECS is 3. Note: For low activity source databases, you could lower the setting below 1 second to reduce latency. However, it may adversely impact the source database when the source workloads increase. Any changes from the default setting should be thoroughly tested before implementing this setting.

Syntax

EOFDELAY seconds | EOFDELAYCSECS centiseconds

seconds

The delay, in seconds, before searching for data to process.

centiseconds

The delay, in centiseconds, before searching for data to process.

Example

EOFDELAY 3