Verify change data capture - 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 updated
2024-11-25
Published on
2024-11-25T15:05:48.570404
To verify change data capture
  1. Make sure that the component configuration and environment preparation activities have been completed.
  2. Execute an IMS online transaction, updating the candidate segments that are to be captured
  3. Execute a BMP program, updating the candidate segments that are to be captured.
  4. Execute a DL/I Batch program, updating the candidate segments that are to be captured.
  5. REPRO (using IDCAMS) the System LogStream dataset to view the records. You should see the changed data records for the files that were updated. The contents of the captured changed data records can be viewed and verified using JCL similar to sample member IXCMCOPY included in the distribution. The JCL should be edited to conform to the operating environment.
Note: The parameter SUBSYS=(LOGR)specifies that the input to IDCAMS is a LogStream where the physical file names will have system generated prefix and suffix added to the LogStream name specified at creation, in our example "SQDATA.IMSC.LOG1". Depending on your system configuration you may find the physical file names prefixed with "IXGLOGR".
//IXCMCOPY JOB 1,MSGLEVEL=(1,1),MSGCLASS=H,NOTIFY=&SYSUID              
        //*                                                                    
        //*--------------------------------------------------------------------\
        //*   Dump the Contents of a System Logstream                          
        //*--------------------------------------------------------------------
        //*********************************************************************
        //*                                                                    
        //REPRO    EXEC PGM=IDCAMS,REGION=2M                                  
        //SYSPRINT DD SYSOUT=*                                                
        //SYSIN    DD *                                                        
        REPRO INFILE(INLOG)  OUTFILE(OUTFILE)                                
        /*                                                                    
        //INLOG    DD SUBSYS=(LOGR),                                          
        //            DSN=SQDATA.IMSCDC.LOG1,                                  
        //            DCB=(BLKSIZE=4096,RECFM=VB)                              
        /*                                                                    
        //OUTFILE  DD DISP=SHR,DSN=SQDATA.REPRO  

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