Verify changed data capture - connect_cdc_sqdata - Latest

To confirm that the Keyed File Compare Capture is working, you should perform the following steps before starting the CDCzLog Publisher Agent.

1. Make sure that the environment preparation and component configuration activities have been completed.
2. Prepare the two Files that will be compared. If necessary make a backup of the existing file, update the original file using whatever means available.
3. Execute the Keyed File Compare against the backup and current version of the file.
4. Dump (using SQDUTIL) the System Logger LogStream dataset to view the records. You will see the changed data records for the files that were updated. The contents of the captured changed data records can be viewed and verified by using JCL similar to sample member SQDUTIL included in the distribution. The JCL should be edited to conform to the operating environment.

//SQDUTIL  JOB 1,MSGLEVEL=(1,1),MSGCLASS=H,NOTIFY=&SYSUID
//*
//*--------------------------------------------------------------------
//*   Execute General Purpose Utility Program - SQDUTIL
//*--------------------------------------------------------------------
//*   Note: 1) All parameters must be entered in lower case
//*
//*         2) Refer to the SQDUTIL Reference for details
//*            regarding functions and parameters
//*
//*********************************************************************
//*
//JOBLIB   DD DISP=SHR,DSN=SQDATA.V400.LOADLIB
//*
//SQDUTIL  EXEC PGM=SQDUTIL
//SQDPUBL  DD DSN=&SYSUID.NACL.PUBLIC,DISP=SHR
//SQDPKEY  DD DSN=&SYSUID.NACL.PRIVATE,DISP=SHR
//SQDPARMS DD *
dump zlog:///SQDATA.FILECDC.LOG1
//SYSPRINT DD SYSOUT=*
//SYSOUT   DD SYSOUT=*
//*SQDLOG8  DD DUMMY
//SQDLOG   DD SYSOUT=*
//*
//

If above tests work as described, the Capture agent is configured properly. If you have problems with any of the steps, go back through the Implementation Checklist and Configuration sections to verity that all of the steps have been completed.