Preventing audits of tables
You can use the AUDIT NONE clause in the ALTER TABLE statement to prevent auditing of a table.
About this task
For the CREATE TABLE statement, the default audit option is NONE. For the ALTER TABLE statement, no default option exists. If you do not use the AUDIT clause in an ALTER TABLE statement, the audit option for the table is unchanged.
If an ALTER TABLE statement turns auditing on or off for a specific table, any packages that use the table are invalidated and must be rebound. If you change the auditing status, the change does not affect packages, or dynamic SQL statements that are currently running. The change is effective only for packages or dynamic SQL statements that begin running after the ALTER TABLE statement has completed.
Procedure
To prevent audits of tables:
ALTER TABLE DSN8C10.DEPT
AUDIT NONE;