The DISABLE AUDIT LOGGING statement stops audit logging for the DBEnvironment session. It allows you to avoid creating audit log records for SQL statements while hard resynchronization is performed.
Scope |
 |
ISQL or Application Programs
SQL Syntax |
|
Description |
|
This statement disables audit logging in the current
session only. It suspends the generation of audit log records for any statements
issued during the session.
This statement and ENABLE AUDIT LOGGING are not used to
turn on and off the AUDIT LOG option specified for processing of all sessions
in the DBEnvironment. These statements affect your current session only.
(The statements that affect all processing in the DBEnvironment are
the START DBE NEW and START DBE NEWLOG statements.)
This statement is not affected by transaction management statements
and remains in effect until an ENABLE AUDIT LOGGING statement
is issued, or until the end of the current session.
Authorization |
|
This statement requires DBA authority.
Example |
|
Perform an initial load of a table without audit logging.
DISABLE AUDIT LOGGING;
LOAD FROM INTERNAL PartsData TO PurchDB.Parts;
COMMIT WORK;
|
Reenable audit logging and continue.
