Field Descriptions (Audit Detail Report and Audit Trace)

This topic contains column descriptions for the audit detail report and audit trace.

OMEGAMON for Db2® Performance Expert identifiers
The identifiers define the order of the Audit data reported. If the requester location differs from the local location, the report or trace shows REQLOC together with the appropriate name under the first column of identifiers.

The member name (MEMBER) is printed if you requested a group-scope report or trace.

TIMESTAMP
The timestamp of the event in the format: MM/DD/YY HH:MM:SS:uu
TYPE
The type of event being reported. You can control which of the events is reported using TYPE with INCLUDE or EXCLUDE. Possible values are:
Type
Description
AUTHCHG
Authorization change.
AUTHCNTL
Authorization control.
AUTHFAIL
Authorization failure.
BIND
Audited DML at bind access.
DDL
Audited DDL access.
DML
Audited DML access.
UTILITY
Audited utility access.
DETAIL
Each event has its own specific detail.

Your selection for the TYPE option determines which of the fields described on the following pages is printed.