HP 3000 Manuals HP 3000 Manuals
ENABLE AUDIT LOGGING
The ENABLE AUDIT LOGGING statement restarts audit logging for the
DBEnvironment after a DISABLE AUDIT LOGGING has been performed.
Scope
ISQL or Application Programs
SQL Syntax
ENABLE AUDIT LOGGING
Description
* This statement reenables audit logging in the current session
only.
* 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 a
DISABLE AUDIT LOGGING statement is issued.
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;