Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Db2 13.1 image-2024-5-19_8-5-1.png .

Auditing a table

To audit a table, you must include the AUDIT clause in the CREATE TABLE or ALTER TABLE statement.

Use the following SQL statements to invoke or remove auditing on tables:

SQL statement

Description

CREATE TABLE AUDIT(ALL)

enables auditing of a table on first READ, first UPDATE, or change within a COMMIT scope, when -START TRACE(AUDIT) CLASS(4,5) is active

CREATE TABLE AUDIT(NONE)

disables auditing of a table, even if -START TRACE(AUDIT) CLASS(4,5) is active

CREATE TABLE(CHANGES)

enables auditing of a table on first INSERT, UPDATE, or DELETE within a COMMIT scope, when -START TRACE(AUDIT) CLASS(5) is active


Related topic

Collecting-SMF-data


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*