Default language.

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:

Related topic

Collecting-SMF-data

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


 

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