Configure new keyed file compare 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 edition
2024-09-13
Last publish date
2024-09-13T19:10:49.846957
Each pair of files processed by the Keyed File Compare Capture requires a new Job or additional job steps in an existing Job. The CDC records themselves may be written to an existing or new LogStream. In our example the new file pair are 'SQDATA.FILEB' and 'SQDATA.FILEB.BAC'. The JCL and the Runtime Parameters will look like the following:
//SQDDFCDC JOB 1,MSGLEVEL=(1,1),MSGCLASS=H,NOTIFY=&SYSUID
//*
//*-----------------------------------------------------------------
//*   SAMPLE JCL FOR THE FILE COMPARE DATA CAPTURE AGENT            *
//*-----------------------------------------------------------------
//SQDDFCDC EXEC PGM=SQDDFCDC,REGION=0M,PARM='DD:SQDPARM'
//STEPLIB  DD DISP=SHR,DSN=SQDATA.V400.LOADLIB
//SYSPRINT DD SYSOUT=*
//SQDLOG   DD SYSOUT=*
//SQDPARM DD *
OLDDS='SQDATA.FILEB.BAC'            -- OLD FILE NAME - USE SINGLE QUOTES
NEWDS='SQDATA.FILEB'                -- NEW FILE NAME - USE SINGLE QUOTES
RPTFREQ=1000                        -- REPORT FREQUENCY
CMITFREQ=1000                       -- COMMIT FREQUENCY
RECALIAS=FILEB                      -- RECORD ALIAS SPECIFIED IN ENGINE
OUTURL=zlog://SQDATA.FILECDC.LOG1   -- TARGET LOG STREAM
KEYOFF=1                            -- OFFSET OF KEY
KEYLEN=10                           -- LENGTH OF KEY