ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 567
SQL Statements S - Z
START DBE NEWLOG
SQL Syntax — NewLogDefinition
LOG DBEFILE DBELog1ID [AND DBELog2ID ]
WITH PAGES =
DBELogSize ,
NAME = '
SystemFileName1 ' [AND ' SystemFileName2 ']
Parameters — NewLogDefinition
LOG DBEFILE describes the two log files if the DUAL LOG option is specified, or a single
log file otherwise.
DBELog1ID and DBELog2ID are the basic names identifying the log files.
DBELogSize specifies the number of 512-byte pages in one log file. If dual logging is
used, both logs must be the same size. The DBE log size should be at least
250 pages and no greater than 524,287 pages. The default is 250. If you
choose an odd number of pages, the number is rounded up to an even
number.
SystemFileName1 and SystemFileName2 identify how the logs are known to the
operating system. The logs are created relative to the DBECon file
directory unless an absolute path name is specified. If a log file by the
same name already exists, use SQLUtil to purge it before issuing the
START DBE NEWLOG statement.
Description
• The usual reason for using START DBE NEWLOG is to increase or decrease log file space
or to invoke dual logging.
• The logs are always created in the same group and account as the DBEnvironment.
• When you choose an odd number of log pages using the WITH PAGES clause of the new
log definition, the number is rounded up to an even number, which is displayed in
SHOWLOG.
• Do not use this statement unless you are certain that the preceding termination of
ALLBASE/SQL was normal and all active sessions terminated normally. Before using
the START DBE NEWLOG statement, it is recommended that you issue a START DBE
statement in single user mode to ensure the DBEnvironment is in a consistent state
before the existing log(s) are disassociated from the DBEnvironment.
• Use the ARCHIVE option
only as a part of a static backup procedure with archive
logging. Refer to the "Backup and Recovery" chapter in the ALLBASE/SQL Database
Administration Guide for more information. The preferred method for starting archive
logging is to use the SQLUtil STOREONLINE command after initial loading of the
DBEnvironment is complete.
• No DBE sessions for the DBEnvironment can be in effect when this statement is
processed.
• Timeout values set in the START DBE NEWLOG statement remain in effect only as long
as there is a DBEnvironment session connected to the DBEnvironment, and do not
modify the values stored in the DBECon file.