Using the Catalog Synchronization Utility › Specifying JCL › CADB2SY0 JCL

CADB2SY0 JCL

Below is sample JCL that you can use to execute CADB2SY0:

//jobname JOB acct.info,’DB2.INCR.SYNCH’,MSGCLASS=A,MSGLEVEL=1
//*
//PRESCAN EXEC PGM=CADB2SY0,REGION=4M
//STEPLIB  DD DISP=SHR,DSN=CAI.CAILIB,
//SYSOUT   DD SYSOUT=*
//RECMAN1  DD DISP=SHR,DSN=SYS1.MAN1,          synchronization SMF dataset
//SYSMDUMP DD DISP=OLD,DSN=CAI.CADB2SY2.DUMP   diagnostic dump
//RECOUT   DD DISP=OLD,DSN=CAI.CADB2SY2.PSMF   output SMF records
//SYSIN    DD *
SELECT(0)
//*
//*

Files

CADB2SY0 uses the files described below:

STEPLIB

(Optional) Identifies a data set that contains CA ACF2 Option for DB2 load modules. This statement is not required if CAI.CAILIB contains these load modules and is included in the link list concatenation

SYSOUT

(Required) Specifies a file to which reporting information, error messages, statistics, and so on, is written. The data set characteristics are LRECL=121 and RECFM=FA or FBA.

SYSMDUMP

(Optional) Specifies a data set to which a dump is written if this job abends.

RECMANxx

(Required) Identifies the file or files containing the synchronization SMF records. CADB2SY0 processes any number of RECMAN or RECMANxx DD statements as synchronization. At least one is required. You cannot concatenate two or more SMF data sets under a single RECMANxx DD statement. To process multiple synchronization data sets, you must use multiple RECMANxx DD statements—one for each synchronization file. Your RECMAN ddname does not require a suffix, CADB2SY0 selects any DD statement that begins with the character string RECMAN.

RECOUT

(Required) Specifies a data set that contains extracted SMF records. The data set characteristics are LRECL=32756 and RECFM=VBS.

SYSIN

(Required) Contains the CADB2SY0 execution parameter, SELECT. You can specify SELECT(nn) to determine the synchronization SMF records this job selects. You must specify a value from 0 through 90 since there is no default. Specify:

0—To select only those records written today, ignoring all others.

1—To select those records written today and yesterday, ignoring all others.

n—To select those records written today and the previous n days, ignoring all others.

Use caution when selecting this value. Consider any site‑specific procedures to deal with synchronization data processing. For example, SMF data is frequently collected on tape using generation data groups (GDG) to manage the data. This archive processing might be done on a scheduled basis, providing regularity in the data collected. The archive processing might also be done on an as‑needed basis, such as when the SMF data sets get full and trigger a switch. Such archived data might be for a wide range of dates.

Required Privileges

To run CADB2SY0 against SMF records, you must have the unscoped audit or the unscoped security privilege. This ensures that all SMF records are available for this job.

Return Codes

CADB2SY0 generates the following return codes: