Using the Catalog Synchronization Utility › Using the Catalog Synchronization Utility Reports › Using the CADB2SY2 Reports › CADB2SSV—Synchronization Control Statement Report › CADB2SGS—DB2 SQL Generated Statement Report

CADB2SGS—DB2 SQL Generated Statement Report

The CADB2SY2 job performs resource validation calls based on the information the INCLUDE and EXCLUDE statements provide. From the results of these calls, CADB2SY2 generates SQL GRANT and REVOKE statements that bring the DB2 catalog up to date with the CA ACF2 Option for DB2 rules.

The CADB2SGS report lists the GRANT and REVOKE statements that are generated as a result of the resource validation calls. CADB2SY2 writes these statements to the GRANTS and REVOKES files.

The exception to this is that if you specified VIEW ACTION(WARN) in your input control statement, CADB2SY2 does not include in the REVOKES file any statement that, if executed, would drop a view. Instead, these REVOKE statements are listed in the CADB2SGS report and are accompanied by CAD2236I messages that list the names of the views that are dropped if the REVOKES are executed. You can edit the statements in the GRANTS and REVOKES files before executing them in DB2.

‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
04/11/99 10.05        CADB2SGS DB2 SYNCHRONIZATION UTILITY ‑ DB2 SQL GENERATED STATEMENT REPORT    BATCH   1  PAGE   1
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑

                                        DB2 SQL GENERATED STATEMENTS
           ====================================================================================================

           REVOKE  DISPLAYDB, STARTDB, STOPDB ON DATABASE EMPDB01 FROM RRUS8 BY ALL
           GRANT   EXECUTE ON PLAN DSNESPCS TO RRUS8
           GRANT   EXECUTE ON PLAN DSNESPRR TO RRUS8
           REVOKE  EXECUTE ON PLAN DSNTIA23 FROM RRUS8 BY ALL
           REVOKE  DBADM ON DATABASE EMPDB01 FROM TEST1 BY ALL
           REVOKE  USE OF BUFFERPOOL BP0 FROM USER1 BY ALL
           GRANT   DBADM ON DATABASE PAYDB01 TO USER1 WITH GRANT OPTION
           REVOKE  SYSADM FROM USER1 BY ALL
           REVOKE  SYSADM FROM USER5 BY ALL
           GRANT   DBADM ON DATABASE EMPDB01 TO USER5 WITH GRANT OPTION
           GRANT   USE OF BUFFERPOOL BP1 TO USER6
           REVOKE  DBADM ON DATABASE EMPDB01 FROM USER6 BY ALL
           GRANT   USE OF BUFFERPOOL BP1 TO USER7
           GRANT   DROP, LOAD, CREATETAP ON DATABASE EMPDB01 TO USER7
           GRANT   USE OF BUFFERPOOL BP0 TO PUBLIC
           GRANT   EXECUTE ON PLAN DSNTIA23 TO PUBLIC