Previous Topic: TSSRECVR JCLNext Topic: TSDB2SY2 JCL

Using the Catalog Synchronization Utility › JCL Information › TSDB2SY1 JCL

TSDB2SY1 JCL

The following is the sample JCL that you can use to execute TSDB2SY1:

//jobname    JOB ACCTINFO,'DB2.INCR.SYNCH',CLASS=A,MSGCLASS=X,
//           MSGLEVEL=1
//INCR       EXEC PGM=TSDB2SY1,REGION=4M
//STEPLIB    DD DISP=SHR,DSN=CAI.CAILIB
//           DD DISP=SHR,DSN=DB2.DSNLOAD     DB2 load library
//SYSOUT     DD SYSOUT=*
//CADB2SNAP  DD DISP=OLD,DSN=CAI.TSDB2SY1.SNAP   diagnostic file
//SYSMDUMP   DD DISP=OLD,DSN=CAI.TSDB2SY1.DUMP   diagnostic dump
//CHGCMDS    DD DISP=SHR,DSN=CAI.TSSRECVR.CMDS
//SYNCHOUT   DD DISP=OLD,DSN=CAI.TSDB2SY2.SYSIN
//SYSIN      DD *
SYSTEM(ssss),SELECT(nn)
/*

Files

TSDB2SY1 uses the files described:

STEPLIB (optional)

Specifies a library containing IBM DB2, represented by DB2.DSNLOAD and CA Top Secret Option for DB2, represented by CAI.CAILIB, load modules. This statement is not required if these libraries are 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, RECFM=FA or FBA.

CADB2SNAP (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.

CHGCMD (required)

Identifies the files containing the input for the CA Top Secret Option for DB2 change commands (PERMIT, DELETE, ADDTO, etc.). This file was created by the TSSRECVR utility.

SYNCHOUT (required)

Identifies the data set that contains the generated synchronization control statement for the TSDB2SY2 job. This data set is the output from the incremental synchronization. The data set characteristics are LRECL=80, RECFM=F or FB.

SYSIN (required)

Contains the TSDB2SY1 execution parameters. SYSTEM identifies the DB2 subsystem for incremental synchronization. SELECT identifies the number of days from today to search backwards in the DB2 catalog for newly created resources. You can specify the following:

SYSTEM(ssss),SELECT(nn)

where

ssss

Selects a single, nonmasked DB2 subsystem ID for which synchronization control statements are generated for TSDB2SY2 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 TSDB2SY1 job ensures that this subsystem exists. Then, it builds synchronization control statements specific to the release of DB2 being used. TSDB2SY1 builds a SYNC control statement using this subsystem name.

nn

Indicates a value from 0 though 90. Specify:

0-To select those resources created today.

1-To select those resources created today and yesterday.

n-To select those resources created today and the previous n days.

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

Required Privileges

To run TSDB2SY1 you must be an unscoped SCA. In addition, you must have the CA Top Secret Option for DB2 EXECUTE privilege for the CADB2S0D application plan.

Return Codes

TSDB2SY1 generates the following return codes: