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
Example
EOFDELAY 3