Report Position Interval
Use this system parameter to set how often (in milliseconds) the CDC Replication Engine for Db2® for i informs the target system about its log position.
Versions supported—CDC Replication Engine for Db2 for i version 6.1 and later
When the source system is in idle mode and there are no log entries for the subscription, the source system informs the target system of its current log position. The target system uses this information to advance its bookmarks.
Note the following considerations when setting this system parameter:
- If the number of milliseconds is set low, then the target system can provide accurate progress notifications that indicate how far replication has progressed.
- If the number of milliseconds is set high, it may affect the accuracy of the information displayed in progress and bookmark notifications.
- If you set a value outside the acceptable range, then the CDC Replication Engine for Db2 for i uses the defaults.
- This system parameter can also prevent the CDC Replication Engine for Db2 for i from rereading log entries that do not apply to the table currently being replicated.
- Applies to
- Source datastores
- Minimum Setting
- 1000 milliseconds (1 second)
- Maximum Setting
- 300000 milliseconds (300 seconds)
- Default Setting
- 5000 milliseconds (5 seconds)