Connect CDC SQData

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 SQDATA.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.

To create a SQDATA.CHURNING table, use the following schema and the DB2 Log Reader Capture will automatically pick up all DB2 log changes.

CREATE TABLE SQDATA.CHURNING

(

COMMENT VARCHAR(128) NOT NULL

)

IN SQDATADC.SQDCHURN

DATA CAPTURE CHANGES;

 

COMMIT;

Next, stop and restart the DB2 capture agent.