Log buffer delays - connect_cdc_sqdata - Latest

The Connect CDC (SQData) Db2/z Log Reader Capture constantly monitors the Db2 transaction log for new data. However, in some environments with low transaction activity, the DB2 log buffer may not be flushed frequently, which can delay the capture of recent data changes. Flushing the Db2 Log buffer can reduce the delay of captured data. One way to accomplish that is to create a special SQDCDC.CHURNING table that the Db2/z Log Capture will then itself update, triggering log records that flush the log buffer in order to pick up all other recent log changes.

CREATE TABLE SQDCDC.CHURNING
(
COMMENT VARCHAR(128) NOT NULL
);
ALTER TABLE SQDCDC.CHURNING DATA CAPTURE CHANGES;

Next, stop and restart the DB2 capture agent.