The Audit Log
For each SQL statement that accesses an audited table,SQL/AF records following
data in a CMS file, called the audit log:
-
the date and time of statement execution
-
the VM and DB2 name of the user executing the statement
-
the name of the terminal originating the statement
-
the name of the package containing the statement
-
the statement type (SELECT, INSERT, ...)
-
the number of rows affected by the statement
-
the LUW status for the statement (committed or rolled-back)
-
the "SQLCODE" associated with the statement
-
the text of the SQL statement, as executed by DB2/VM, which means that:
-
all host variables are replaced with their contents
-
special registers (eg CURRENT DATE) are replaced with their actual value
-
some statement predicates are modified so that they always show which data
rows are accessed (e.g. the WHERE CURRENT OF CURSOR clause)