Testing that your exit routine is active

You can test if your exit routine is active by causing an authorization failure.

About this task

When you complete this test, you will know if RACF is performing Db2 authorization checking. If it is, the RACF access control module is active.

Also, you might check the Db2 trace facility. The Db2 trace record IFCID 314 is only generated when the RACF access control module is active.

Procedure

To test if your exit routine is active:

  1. Choose a RACF-defined Db2 table on which to execute a SELECT statement and choose an authorization ID to run the SELECT statement.
    The authorization ID must not own the table and have none of the following access authorizations:
    • Db2 administrative authority (installation SYSADM, SYSADM, SYSCTRL, or DBADM for the database containing the table. If the table is in an implicitly created database, DBADM should not be held on DSNDB04.)
    • Db2 SELECT privilege on the chosen table
    • RACF authorization for the SELECT privilege on the chosen table
    • RACF authorization for READ access to the chosen table
  2. Use the authorization ID to run a SELECT statement on the table.
    The SELECT statement should fail.
  3. Review the resulting ICH408I information messages related to Db2 resources and examine the RACF return code.