|
Configure New Keyed File Compare Capture |
Scroll |
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
