Specifying AUDIT for certain tables

In addition to starting the traces, AUDIT must be in effect for the desired tables if monitoring of IFCIDs 143, 144 or 145 is to be effective. For each DB2 table to be audited, you must specify AUDIT access where access is CHANGES to audit only writes, or ALL to audit both reads and writes. You might specify AUDIT when the table is created or subsequently with an ALTER TABLE statement. A full discussion of DB2 table auditing is beyond the scope of this space.