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 while hard resynchronization is performed.
Scope
ISQL or Application Programs
SQL Syntax
DISABLE AUDIT LOGGING
Description
* This statement disables audit logging in the current session only.
It is usually used in conjunction with the ENABLE AUDIT LOGGING
statement to perform bulk operations that do not require audit
logging, or to permit a hard resynchronization without the
generation of audit log records in an ALLBASE/Replicate
DBEnvironment in which audit logging is enabled.
* 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.)
* When performing a hard resynchronization of a partition with
ALLBASE/Replicate, it is necessary to disable audit logging while
loading data. Then you should reenable audit logging so that
audit log records will be generated for new transactions.
* This statement is not affected by transaction management
statements (such as COMMIT WORK) 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;