Using the Catalog Synchronization Utility › Using the Catalog Synchronization Utility Reports › Using the CADB2SY2 Reports › CADB2SSV—Synchronization Control Statement Report

CADB2SSV—Synchronization Control Statement Report

The CADB2SSV report lists the synchronization control statements and reports any syntax errors it finds. A sample synchronization control statement report with errors is shown below.

‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
04/11/99 10.03          CADB2SSV DB2 SYNCHRONIZATION UTILITY ‑ SYNCHRONIZATION CONTROL STATEMENT REPORT     PAGE   1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑

                     SYNCHRONIZATION CONTROL STATEMENT
                     ================================================================================

                         SYNC SYSTEM(PROD) OPTIONS(TRACE,NOPRIVCHECK)

                         /* SELECT USERS TO BE PROCESSED */
                         INCLUDE USER(ARDUV03)
                         INCLUDE USER(USER‑)
                         EXCLUDE USER(USER2)
                         EXCLUDE USER(USER3)
                         INCLUDE IF(SECURITY)
                         INCLUDE IF(DB2PROD)
                         EXCLUDE UID(********RESEARCH)
                         INCLUDE USER(TEST*)
                         INCLUDE USER(WGGAB01)

                         /* SELECT DB2 RESOURCES TO BE PROCESSED */
                         INCLUDE BPL(BP*)


 CAD2018E *Error*        INCLUDE DATABASE(PAY****)
 CAD2019E Keyword:               *
 CAD2021E CADB2SSV Input control statement parse error RC=08 (INVALID KEYWORD)

 CAD2031E Errors detected in input control statement scan, execution terminated

After you correct the errors, the corrected synchronization control statements synchronize the CA ACF2 Option for DB2 rules with the DB2 catalog of the PROD DB2 subsystem. Users who match the INCLUDE and EXCLUDE criteria are correlated with the DB2 resource criteria shown below.

‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
04/11/99 10.05          CADB2SSV DB2 SYNCHRONIZATION UTILITY ‑ SYNCHRONIZATION CONTROL STATEMENT REPORT       PAGE   1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑

                     SYNCHRONIZATION CONTROL STATEMENT
                     ================================================================================

                         SYNC SYSTEM(PROD) OPTIONS(TRACE,NOPRIVCHECK)

                         /* SELECT USERS TO BE PROCESSED */
                         INCLUDE USER(ARDUV03)
                         INCLUDE USER(USER‑)
                         EXCLUDE USER(USER2)
                         EXCLUDE USER(USER3)
                         INCLUDE IF(SECURITY)
                         INCLUDE IF(DB2PROD)
                         EXCLUDE UID(********RESEARCH)
                         INCLUDE USER(TEST*)
                         INCLUDE USER(WGGAB01)

                         /* SELECT DB2 RESOURCES TO BE PROCESSED */
                         INCLUDE BPL(BP*)
                         INCLUDE DBS(PAY****)
                         INCLUDE DBS(EMP‑)
                         INCLUDE PLN(DSN‑)
                         INCLUDE SYS(SYSADM)
                         INCLUDE TBL(ACCTPAY.XREF)
                         INCLUDE TBL(ORDER.DV‑)

                      GO

 CAD2022I Input control statement scan successful
 CAD2024I Synchronization in progress for CA Security system CA ACF2
 CAD2025I Synchronization in progress for DB2 subsystem PROD

The GRANT and REVOKE statements that these statements generate are shown in the CADB2SGS report.