ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 563
SQL Statements S - Z
START DBE NEWLOG
START DBE NEWLOG
The START DBE NEWLOG statement establishes a connection with a given DBEnvironment
and creates one or two new log files for that DBEnvironment. It establishes a set of startup
parameters that apply to this and all subsequent connections until all connections to the
DBEnvironment have been terminated. Any start up parameters not explicitly specified
are taken from the DBECon file except the enabling of audit logging. This statement
reinitializes log file(s) when you need to change the size, invoke a dual logging or startup,
or alter audit logging.
Scope
ISQL or Application Programs
SQL Syntax — START DBE NEWLOG
START DBE ‘DBEnvironmentName’ [AS ‘ConnectionName’ ][MULTI]NEWLOG
[{ARCHIVE
DUAL
AUDIT}|...|LOG
BUFFER = ( DataBufferPages, LogBufferPages )
TRANSACTION = MaxTransactions
MAXIMUM TIMEOUT = { TimeoutValue [SECONDS
MINUTES]
NONE }
DEFAULT TIMEOUT = { TimeoutValue [SECONDS
MINUTES]
MAXIMUM }
RUN BLOCK = ControlBlockPages
DEFAULT PARTITION = { DefaultPartitionNumber
NONE }
COMMENT PARTITION = { CommentPartitionNumber
DEFAULT
NONE }
MAXPARTITIONS = MaximumNumberOfPartitions
AUDIT NAME = ‘AuditName’
{COMMENT
DATA
DEFINITION
STORAGE
AUTHORIZATION
SECTION
ALL }|...|AUDIT ELEMENTS ]|,...| NewLogDefinition
Parameters — START DBE NEWLOG
DBEnvironmentName identifies the DBEnvironment in which you want to initialize one
or two new log files. Unless you specify an absolute path name,
ALLBASE/SQL assumes the name is relative to your current working
directory.
ConnectionName associates a user specified name with this connection. This name must