REPORTPOSITIONINTERVAL

Read syntax diagramSkip visual syntax diagram REPORTPOSITIONINTERVAL=5seconds

Specifies how often, in seconds, the source environment informs the target environment about its position in the Db2® log during idle periods after starting mirroring.

In the target environment, a bookmark is a value that represents the last processed Db2 log position on the source environment. During idle periods, when there are no log entries to process within replication scope, the source environment informs the target environment of its current position in the log so that the target environment can advance its bookmarks accordingly. By decreasing the setting for this keyword, the target environment can reflect more accurately how far mirroring has progressed through the logs. In addition, regularly synchronizing the bookmarks with the source environment can reduce the number of entries that have to be read again when mirroring is restarted.

CAUTION:
The value assigned to this keyword affects the information presented in specific messages and in the Monitoring perspective of Management Console. Increasing this setting may result in information that is not up-to-date.

This keyword is optional.

Default Setting—5 seconds

Minimum Setting—1 second

Note: If you specify a value smaller than the minimum setting or larger than the maximum setting, then CDC Replication uses the default value.

Maximum Setting—300 seconds