Using the Catalog Synchronization Utility › JCL Information › TSDB2SY3 JCL

TSDB2SY3 JCL

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

//jobname  JOB acct.info,'DB2 SYNCH',CLASS=A,MSGCLASS=1
//TSDB2SY3 EXEC PGM=TSDB2SY3,REGION=2M
//STEPLIB  DD DISP=SHR,DSN=CAI.CAILIB
//         DD DISP=SHR,DSN=DB2.DSNLOAD         DB2 load library
//CAD2SNAP DD DISP=OLD,DSN=CAI.TSDB2SY3.SNAP   diagnostic file
//SYSMDUMP DD DISP=OLD,DSN=CAI.TSDB2SY3.DUMP   diagnostic dump
//SYSOUT   DD SYSOUT=*
//SYSIN    DD DISP=SHR,DSN=CAI.TSDB2SY2.REVOKE input REVOKE statements
//         DD DISP=SHR,DSN=CAI.TSDB2SY2.GRANT  input GRANT statements

Files

TSDB2SY3 uses the files described.

STEPLIB (optional)

Specifies two libraries 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 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 for diagnostic purposes.

SYSIN (required)

Contains the SQL GRANT and REVOKE statements. The TSDB2SY2 job generates these statements and writes them to the TSDB2SY2 GRANT and REVOKE files, which you should use as input here. The first statement in each of these files is a special, fixed format, control statement that identifies the DB2 subsystem being synchronized. Do not modify this statement.

You must concatenate the REVOKES file before the GRANTS file. This ensures that TSDB2SY3 executes the REVOKE statements before the GRANT statements. The data set characteristics must be LRECL=255 and RECFM=VB.

Required Privileges

To run TSDB2SY3 you must have both of these privileges:

• CA Top Secret Option for DB2 EXECUTE privilege for application plan CADB2SES
• Native DB2 SYSADM privilege.

We also recommend that you have the SYSADM system privilege in CA Top Secret Option for DB2 so that a REVOKE SYSADM statement is not generated for your ID when the REVOKEALL option is specified in the TSDB2SY2 component. Any grants or revokes for the userid used to run TSDB2SY3 is rejected by DB2. This is because DB2 does not allow users to grant or revoke privileges to themselves. We therefore suggest that you create a special ID used only for running the Catalog Synchronization Utility and add an EXCLUDE USER control statement in TSDB2SY2 for that userid as the last control statement of every batch.

Return Codes

TSDB2SY3 generates the following return codes:

• 00-Processing completed successfully. DB2 GRANT/REVOKE statements have been processed successfully.
• 04-Processing completed with warning messages. Review messages.
• 08-Errors occurred during processing. One or more error messages are issued with this error. Review the messages and correct the errors as appropriate. Then rerun this job.
• 12-Errors occurred during processing. One or more error messages are issued with this error. Review the messages and correct the errors as appropriate. Then rerun this job.
• 16-Initialization error or error in input parameters. Review error messages that might have been issued with the error. Correct errors as appropriate. Then rerun this job.