HP 3000 Manuals HP 3000 Manuals
DISABLE AUDIT LOGGING
The DISABLE AUDIT LOGGING statement stops audit logging for the
DBEnvironment session. It allows you to avoid creating audit log
records for SQL statements[REV BEG] while hard resynchronization is
performed.[REV END]
Scope
ISQL or Application Programs
SQL Syntax
DISABLE AUDIT LOGGING
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.
ENABLE AUDIT LOGGING;