Please enable JavaScript to view this site.

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/db2cdc1/DB2CDC1.cab

//*