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)