Using the Catalog Synchronization Utility › Specifying JCL › CADB2SY1 JCL

CADB2SY1 JCL

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

//DB2INCR  JOB ACCTINFO,’DB2.INCR.SYNCH’,CLASS=A,MSGCLASS=X,
//         MSGLEVEL=1
//INCR     EXEC PGM=CADB2SY1,REGION=4M
//STEPLIB  DD DISP=SHR,DSN=CAI.CAILIB
//         DD DISP=SHR,DSN=DB2.DSNLOAD         DB2 load library
//SYSOUT   DD SYSOUT=*
//CAD2SNAP DD DISP=OLD,DSN=CAI.CADB2SY1.SNAP   diagnostic file
//SYSMDUMP DD DISP=OLD,DSN=CAI.CADB2SY1.DUMP   diagnostic dump
//RECMAN01 DD DISP=SHR,DSN=SYS1.MAN1
//SYNCHOUT DD DISP=OLD,DSN=CAI.CADB2SY2.SYSIN
//SYSIN    DD *
SELECT(nn),SYSTEM(ssss)
/*

Files

CADB2SY1 uses the files described below:

STEPLIB

(Optional) Specifies libraries containing the IBM DB2 load modules, represented by the DB2.DSNLOAD library, and CA ACF2 Option for DB2 load modules, represented by the CAI.CAILIB library. These statements are not required if these libraries are 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, RECFM=FA or FBA.

CAD2SNAP

(Optional) Specifies an optional file that is used to debug DB2 errors. The data set characteristics are LRECL=125 and RECFM=VA or VBA.

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 or preprocessed SMF records from CADB2SY0. CADB2SY1 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 statement—one for each synchronization file. Your RECMAN ddname does not require a suffix, CADB2SY1 selects any DD statement that begins with the character string RECMAN.

SYNCHOUT

(Required) Identifies where to write the generated control statements for CADB2SY2. The data set characteristics are LRECL=80, RECFM=F or FB.

SYSIN

(Required) Contains the CADB2SY1 execution parameters. These parameters determine the synchronization SMF records and new DB2 resources this job selects. You must specify a value for SELECT and SYSTEM. There are no defaults. Specify:

SELECT(nn),SYSTEM(ssss)

where:

nn

Specifies a value from 0 through 90. Specify:

0—To select only those SMF records written and DB2 resources created today, ignoring all others.

1—To select those SMF records written and DB2 resources created today and yesterday, ignoring all others.

n—To select those SMF records written and DB2 resources created 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.

ssss

Selects a single, nonmasked DB2 subsystem ID for which synchronization control statements are generated for CADB2SY2 to use. This parameter is required, no default subsystem ID is used. The specified subsystem must be defined to the system. Appropriate IEFSSNxx members must exist. Masking is not allowed.

The CADB2SY1 job ensures that this subsystem exists. CADB2SY1 builds a SYNC control statement using this subsystem name. Then, it builds synchronization control statements specific to the release of DB2 being used.

The data set characteristics are LRECL=80, RECFM=F or FB.

Required Privileges

To run CADB2SY1 against SMF records, you must have the unscoped audit or unscoped security privilege. This ensures that all SMF records are available for this job. In addition, you must have the CA ACF2 Option for DB2 EXECUTE privilege for the CADB2S0D application plan.

Return Codes

CADB2SY1 generates the following return codes: