Data stored by audit server

Application data

In accordance with the application user requirement, the audit server reserves an extra four bytes in each audit row, which application programs can use. This 4byte space is called application data. The audit server does not interpret the application data in any way.

Table operations

For table operations such as create table, drop table, and clear table, the audit server stores only a one-byte indicator. If a non-empty table is dropped or cleared, a delete row operation is created for all rows in the table.

Row operations

For row operations, the audit server keeps the values of audited fields. In addition to field values, the audit server also stores a one-character code that indicates the type of row operation.

Insert actions

The new values of all audited fields to be inserted are stored in the audit file.

Delete actions

The field values of the record to be deleted are stored in the audit file.

Update actions

You can set up a configuration to store only the primary key columns and those values that have been changed, or include columns of a record that have not been changed. You use the Audit_cols file to specify whether a column must be logged only when the column’s value changes, or if any other column in the table changes.