LOGREADCOMMITINTERVAL

Read syntax diagramSkip visual syntax diagram LOGREADCOMMITINTERVAL=30time

Specifies how frequently the InfoSphere® CDC for z/OS® threads that read the Db2® log will issue a Db2 COMMIT.

If the value specified for time is non-zero, threads that read the Db2 log will 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 will never issue Db2 COMMITs, which leaves the threads more vulnerable to a class of Db2 bugs that can cause decompression of log records to fail. The more frequently COMMIT is performed, the less chance there is that decompression of Db2 log records will fail. If the value specified for time is less than zero, zero is used. If the value specified for time is greater than the maximum allowable value, the maximum value is used.

This keyword is optional.

Default Setting—30 seconds

Maximum Setting—86400 seconds (86400 seconds is equal to one day)