The Audit report set

With DB2 Audit data you can track Db2 resource access. Audit reports and traces show information about the user of an auditable object and the time and type of action performed on the object.

Audit reports group events in the order of event type, ORDER identifier, and timestamp.

Audit traces show events listed chronologically.

You can use Audit reports and traces to review Audit data by OMEGAMON® XE for DB2 PE identifiers and choose between a wide range of options for presenting DB2 Audit data.

You can order Audit reports and traces by the object of the Audit event (for example, authorization failures per table).

You can produce member-scope and group-scope Audit reports and traces.
  • Member-scope reporting presents data member by member.
  • Group-scope reporting merges the data that is produced by each group member to give a full picture of the use of a shared resource.

You can produce Audit reports and traces of individual Audit events in the order in which they occurred, or reports of aggregated Audit data.

You can specify the level of detail in Audit reports and traces by specifying any combination of the following event types:
  • Authorization failures
  • Changes to authorization identifiers
  • DDL operations against auditable tables
  • DML statements at bind of auditable tables
  • Grants or revokes of privileges
  • Read/write access to auditable tables
  • Utility access to auditable tables