ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 569
SQL Statements S - Z
START DBE NEWLOG
• If an audit parameter is not specified in the statement, the audit parameter remains
unchanged. The parameters AUDIT NAME, DEFAULT PARTITION,
MAXPARTITIONS, COMMENT PARTITION, and AUDIT ELEMENTS can be changed
at any time through the START DBE NEWLOG statement.
• If AUDIT LOG is not specified in this statement, the default is that it is disabled. Thus
if the DBEnvironment had audit logging enabled and then specified a START DBE
NEWLOG statement without AUDIT LOG, audit logging would then be disabled.
• Changing MAXPARTITIONS on a START DBE NEWLOG prevents roll forward recovery
through prior log files, since their structure will differ from the new logs' structure. The
same is true of going from non-audit logs to audit logs and vice versa. Therefore, it is
recommended that an audit DBEnvironment be designed with a large enough
MAXPARTITIONS when it is created.
• Additional log files should be created with the SQLUtil ADDLOG command.
• Refer to the
ALLBASE/SQL Database Administration Guide for additional
information on log file management.
Authorization
You need to be the DBECreator or super-user to issue the START DBE NEWLOG statement.
hpdb must have write permission in the target directory for the log file(s).
Example
The DBEnvironment is restored to a consistent state. Any transactions incomplete when
the DBEnvironment was last shut down are rolled back, and work done by completed
transactions is committed.
START DBE '../sampledb/PartsDBE'
SQLUtil is used to delete the existing log files: PartsLg1 and PartsLg2.
STOP DBE
The log files are reinitialized.
START DBE '../sampledb/PartsDBE' MULTI NEWLOG DUAL LOG
LOG DBEFILE PartsDBELog1 AND PartsDBELog2
WITH PAGES = 250, NAME = 'PartsLg1' AND 'PartsLg2'
The DBEnvironment is restored to a consistent state. Any transactions incomplete when
the DBEnvironment was last shut down are rolled back, and work done by completed
transactions is committed.
START DBE '../sampledb/PartsDBE'
STOP DBE
After the DBEnvironment is stopped, the log files can be purged.