mirror_log_read_commit_interval_seconds

Read syntax diagramSkip visual syntax diagram mirror_log_read_commit_interval_seconds=time

Specifies how frequently the log-reader threads of the CDC Replication Engine for Db2® for z/OS® Remote Source issue a Db2 COMMIT.

If the value that you specify for time is non-zero, threads that read the Db2 log issue a Db2 COMMIT every time seconds, unless the thread has not read any data from the Db2 log since the previous COMMIT was issued. If time is zero, threads that read the Db2 log never issue Db2 COMMIT, which leaves the threads more vulnerable to a class of Db2 bugs that can cause decompression of log records to fail. The more frequently that you COMMIT, the lower the chance that decompression will fail.

Default Setting—30 seconds

Maximum Setting—86400 seconds (one day)