FM/Db2 audit record types
FM/Db2 audit record types shows the FM/Db2 audit record types. Each record type has a single character code.
| 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 FM/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 FM/Db2 function. Each 'S' record should have a corresponding 'Z' record. |
| T | Template record. Contains a File Manager/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 FM/Db2 function. Each 'Z' record should have a corresponding 'S' record. |
| 2 | Contains the text of a Db2® command. This is specific to FM/Db2. |