Connect CDC SQData

The JCL and runtime parameters similar to the following sample member SQDDFCDC is used to execute the Keyed File Capture Agent.

//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.V4xx.LOADLIB

//SYSPRINT DD SYSOUT=*

//SQDLOG   DD SYSOUT=*

//SQDPARM DD *

OLDDS='SQDATA.FILEA.BAC'            -- OLD FILE NAME - USE SINGLE QUOTES

NEWDS='SQDATA.FILEA'                -- NEW FILE NAME - USE SINGLE QUOTES

RPTFREQ=1000                        -- REPORT FREQUENCY

CMITFREQ=1000                       -- COMMIT FREQUENCY

RECALIAS=FILEA                      -- RECORD ALIAS SPECIFIED IN ENGINE

OUTURL=zlog://SQDATA.FILECDC.LOG1   -- TARGET LOG STREAM

KEYOFF=0                            -- OFFSET OF KEY

KEYLEN=6                            -- LENGTH OF KEY