Previous Topic: TSDB2SY1 JCLNext Topic: TSDB2SY3 JCL

Using the Catalog Synchronization Utility › JCL Information › TSDB2SY2 JCL

TSDB2SY2 JCL

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

//jobname  JOB acct.info,'DB2 SYNCH',CLASS=A,MSGCLASS=1
//TSDB2SY2 EXEC PGM=TSDB2SY2,REGION=2M
//STEPLIB  DD DISP=SHR,DSN=CAI.CAILIB
//         DD DISP=SHR,DSN=DB2.DSNLOAD         DB2 load library
//GRANTS   DD DISP=OLD,DSN=CAI.TSDB2SY2.GRANT  generated grants
//REVOKES  DD DISP=OLD,DSN=CAI.TSDB2SY2.REVOKE generated revokes
//CAD2SNAP DD DISP=OLD,DSN=CAI.TSDB2SY2.SNAP   diagnostic file
//SYSOUT   DD SYSOUT=*
//SYSMDUMP DD DISP=OLD,DSN=CAI.TSDB2SY2.DUMP   diagnostic dump
//SYSIN    DD DISP=SHR,DSN=CAI.TSDB2SY2.SYSIN  synchronization control statements
//PUBLIC   DD DISP=SHR,DSN=CAI.TSDB2SY2.PUBLIC input grant to public statements

Files

TSDB2SY2 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.

GRANTS (required)

References the output data set for TSDB2SY2. The SQL GRANT statements generated by processing the input parameters (ddname of SYSIN) against CA Top Secret Option for DB2 information are written to this file. The data set characteristics must be LRECL=255 and RECFM=VB. The block size of the REVOKES file must be equal to or greater than the block size of the GRANTS file because REVOKES are concatenated before GRANTS when the TSDB2SY3 job is run.

REVOKES(required)

References the output data set for TSDB2SY2. The SQL REVOKE statements generated by processing the input parameters (ddname of SYSIN) against CA Top Secret Option for DB2 information are written to this file. The data set characteristics must be LRECL=255 and RECFM=VB.

SYSOUT (required)

Specifies a file to which reporting information, error messages, statistics, and so on, are written. The data set characteristics are LRECL= 121 and 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.

SYSIN (required)

Specifies the synchronization control statements file for TSDB2SY2. This file contains the INCLUDE and EXCLUDE statements, as well as the required SYNC control statement. The data set characteristics are LRECL=80 and RECFM=F or FB. For more information, see the “Specifying Synchronization Control Statements for TSDB2SY2” section.

PUBLIC (required)

Specifies the input GRANT TO PUBLIC control statements for TSDB2SY2. This file contains the resource privileges that you specified which are to be granted to public when corresponding resources are included for synchronization. This is an alternate means of specifying privileges for PUBLIC. For more information, see the “Specifying GRANT TO PUBLIC Control Statements” section. Once this file is used, it should be included for all subsequent synchronizations to avoid generating revokes from PUBLIC. The data set characteristics are LRECL=80 and RECFM=F or FB. Specify DD DUMMY when no GRANT TO PUBLIC control statements are specified.

Required Privileges

To run TSDB2SY2 you must be an unscoped SCA with ADMIN DATA(BASIC) authority. In addition, you must have the CA Top Secret Option for DB2 EXECUTE privilege for these application plans:

Return Codes

TSDB2SY2 generates the following return codes: