Normal restart - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last edition
2024-09-13
Last publish date
2024-09-13T19:10:49.846957

By Default, each time the Db2/z Capture agent starts, data capture is resumed from the last LSN processed. It knows exactly how far back in time to re-mine to guarantee the re-capture of all in-flight transactions for all transactions where the "begin" transaction record was previously seen by the Capture. While re-mining, the Capture may encounter Log records belonging to a transaction for which the begin transaction record was not seen previously. These records are counted as orphan records unless a rollback for the transaction is subsequently seen in the log. If the transaction is rolled back, the orphaned records of that transaction are voided (that is not counted as orphan record). It is possible that the statistics, immediately after a re-start, show some orphan records, but does not show them later.

Example

Resume capture using JCL similar to the following to Mount and Start the Capture Agent.
//SQDDB2C EXEC PGM=SQDDB2C,REGION=0M
//*SQDDB2C EXEC PGM=XQDDB2C,REGION=0M
//SQDPUBL DD DSN=SQDATA.NACL.PUBLIC,DISP=SHR
//SQDPKEY DD DSN=SQDATA.NACL.PRIVATE,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//CEEDUMP DD SYSOUT=*
//SQDLOG DD SYSOUT=*
//*SQDLOG8 DD DUMMY
//*SQDPARMS DD DISP=SHR,DSN=SQDATA.V400.PARMLIB(DB2CDC)
//SQDPARMS DD *
--start 
/home/sqdata/db2cdc/db2cdc.cab 
//*