ALLBASE/SQL Reference Manual (36216-90216)

568 Chapter12
SQL Statements S - Z
START DBE NEWLOG
• If no MAXIMUM TIMEOUT limit is specified, the MAXIMUM TIMEOUT limit stored
in the DBECon file remains in effect. If no DEFAULT TIMEOUT value is specified, the
DEFAULT TIMEOUT value stored in the DBECon file remains in effect.
• If MAXIMUM TIMEOUT = NONE, infinity (no timeout) is assumed. If DEFAULT
TIMEOUT = MAXIMUM, the value of MAXIMUM TIMEOUT is assumed. The
DEFAULT TIMEOUT value may not exceed the MAXIMUM TIMEOUT value.
• The following parameters defined in the START DBE NEW statement are stored in the
DBECon file:
• DBEnvironment language
• User mode (single versus multi)
• Number of data buffer pages
• Number of log buffer pages
• Maximum transactions
• Maximum timeout value
• Default timeout value
• Number of runtime control block pages
• DBEFile0 system file name
• Log system file name(s)
• Audit logging (chosen versus not)
• Audit name
• Audit elements
• Default partition
• Comment partition
• Maximum number of partitions
• You can reconfigure a DBEnvironment by using SQLUtil to alter DBECon file
parameters. All parameters except the audit information (logging, audit elements,
name, default, comment and maximum partition), or the name of the DBECon file and
DBEFile0 may be changed. Refer to the
ALLBASE/SQL Database Administration
Guide
for additional information.
• If AUDIT LOG is specified, the clauses AUDIT NAME, DEFAULT PARTITION, and
MAXPARTITIONS must also be specified. Further, if no AUDIT ELEMENTS are
specified, DATA is used as a default.
• Use of the clause ALL AUDIT ELEMENTS implies specification of all of the audit
elements.
• The usual reason for using START DBE NEWLOG is to increase or decrease log file space,
to invoke dual logging or audit logging, or to alter audit logging parameters.
• Audit parameters set in the START DBE NEWLOG statement modify the values stored in
the DBECon file.