ZDT/Db2 audit record types

Table 1 shows the ZDT/Db2 audit record types. Each record type has a single character code.

Table 1. ZDT/Db2 audit record types
Audit Record Type Code Usage
A New record or row.
D Deleted record or row.
E Enumeration record: reports the number of records or rows read or copied.
I Identification record: contains information about the data set or Db2® object that is being processed.
J Identification record: specific to Db2. Contains the SQL SELECT statement used to access Db2 objects.
O Original record or row. An 'O' record is typically written for an update (change) operation, and is followed by an 'R' record.
Q Contains the text for an SQL statement. This is specific to ZDT/Db2.
R Replacement record or row. An 'R' record is typically written for an update (change) operation, and is preceded by an 'O' record.
S Start of session record. An 'S' record is written at the start of auditing for some ZDT/Db2 function. Each 'S' record should have a corresponding 'Z' record.
T Template record. Contains a ZDT/Db2 template used to process a data set or Db2 object. The template is written in internal format.
Z End of session record. A 'Z' record is written at the end of auditing for some ZDT/Db2 function. Each 'Z' record should have a corresponding 'S' record.
2 Contains the text of a Db2 command. This is specific to ZDT/Db2.