Audit tables

This section shows the structure of each of the Audit tables in the performance database.

Figure 1. The Audit tables
This figure is a graphical representation of the structure of the Audit tables.
Authorization Failures
One row for each authorization failure that occurred
Authorization Control
One row per authorization control issued
Authorization Change
One row for each of the following authorization changes or authorization establishments:
  • SET CURRENT SQLID
  • END OF IDENTIFY
  • END OF SIGNON
  • INBOUND/OUTBOUND DISTRIBUTED TRANSLATION
Audited DDL Access
One row per CREATE or DROP against an Audited object, or ALTER TABLE which change the AUDIT option against an audited table.
Audited DML at Bind Access
One row for each SQL statement that involves audited objects.
Objects in SQL statement
One row for each object involved in the SQL statements recorded in Audited DML at Bind Access.
Audited DML Access
One row for the first change (write) to an audited object in a unit of work
Audited Utility Access
One row for each object and each phase accessed by a utility execution.
SQL Statement
One row for the text of each SQL statement involved in:
  • Authorization Failure
  • Authorization Control
  • Audited DDL Access
  • Audited DML at Bind Access