ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 561
SQL Statements S - Z
START DBE NEW
• The following additional parameters are stored in the DBECon file:
• The autostart flag determines how DBE sessions are started. If the value of
autostart is ON, a DBE session can be established by using the CONNECT statement.
If the value of autostart is OFF, the START DBE statement must be used to start up a
DBEnvironment; if the START DBE statement contains the MULTI option, other
users establish DBE sessions with the CONNECT statement. Autostart is on by
default.
• The DDL Enabled flag determines whether data definition is enabled for the
DBEnvironment. The DDL Enabled flag is set to YES by default. See "Maintenance"
in the
ALLBASE/SQL Database Administration
Guide
for additional information about the DDL Enabled flag.
• The archive mode flag determines whether the DBEnvironment is operating in
archive mode. In archive mode, ALLBASE/SQL does rollforward logging. The
rollforward log can be used to redo transactions in case it is necessary to restore the
DBEnvironment from a backed up (archival) copy. When archive mode has the value
of OFF, log space can be recovered by using the CHECKPOINT statement. If you want
to do rollforward recovery, you must always operate in archive mode. Rollback
recovery is enabled regardless of the archive mode. Archive mode is off by default.
• When you choose an odd number of log pages using the WITH PAGES clause of the
DBEFile definitions, the number is rounded up to an even number, which is displayed
in SHOWLOG.
• The size of DBEFile0 is fixed at the time you configure a DBEnvironment and cannot be
changed. If you need more space at a later time, add a DBEFile to the SYSTEM
DBEFileSet.
• DBEFile0 cannot be restricted to containing data pages only or index pages only; the
storage in DBEFile0 is used for both data and index pages.
• You can reconfigure a DBEnvironment by using SQLUtil to alter DBECon file
parameters. All parameters except the name of the DBECon file and DBEFile0 may be
changed. Refer to the
ALLBASE/SQL Database Administration Guide for
additional information.
• The files created with this statement are owned by hpdb and have the following
permissions:
-rw------
• If no MAXIMUM TIMEOUT limit is specified, or if MAXIMUM TIMEOUT = NONE,
infinity (no timeout) is assumed. If no DEFAULT TIMEOUT value is specified, or if
DEFAULT TIMEOUT = MAXIMUM, the value of MAXIMUM TIMEOUT is assumed.
The DEFAULT TIMEOUT value may not exceed the MAXIMUM TIMEOUT value.
• You cannot use the START DBE NEW statement on a diskless machine. A
DBEnvironment for use in diskless clusters must be created on the cluster server. Refer
to the
ALLBASE/NET User's Guide for further information.
• 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