ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 557
SQL Statements S - Z
START DBE NEW
TimeoutValue is an integer literal greater than zero. If the TimeoutValue is not
qualified by MINUTES, SECONDS is assumed. If representing seconds,
TimeoutValue must be in the range of 1 to 2,147,483,647. If representing
minutes,
TimeoutValue must be in the range of 1 to 35,791,394.
ControlBlockPages specifies the number of runtime control blocks to be allocated. The
value specified is stored in the DBECon file.
You can specify a value from 17 to 2,000 pages for this parameter. The
default is 37 pages. The total number of data buffer pages and runtime
control block pages cannot exceed 256 Mbytes.
DefaultPartitionNumber specifies the default partition number for the
DBEnvironment. This clause must be specified if AUDIT LOG is specified.
DefaultPartitionNumber must be in the range 1 and 32767. If NONE
is specified, tables in the DBEnvironment that are in the default partition
do not generate audit log records. See the CREATE TABLE and ALTER
TABLE statements for information on assigning a table to a partition.
CommentPartitionNumber specifies the partition number for comments made in the
DBEnvironment.
CommentPartitionNumber must be a number between
1 and 32767. If no COMMENT PARTITION is specified, DEFAULT is
implied.
If the comment partition is DEFAULT and the default partition number is
later changed in a START DBE NEWLOG statement (but the comment
partition is not changed from DEFAULT), the comment partition number
will also change to the new default partition number.
MaximumNumberOfPartitions specifies the maximum number of partitions for the
DBEnvironment. This clause must be specified if AUDIT LOG has been
specified.
MaximumNumberOfPartitions is required to be a number
between 1 and 831. This number indicates the number of partition
instances the DBEnvironment is expected to track.
For audit logging purposes, the number of partition instances is calculated
as the sum of the number of DATA partitions and the number of elements
(not counting the DATA element) specified in the AUDIT ELEMENTS
clause. Specifying ALL audit elements (see below) includes 6 elements,
implying that 6 partitions are used. Set this value only as high as needed
so that unnecessary space is not reserved unless you plan more partitions
or audit elements in the future.
AuditName specifies the name of this audit DBEnvironment. AuditName is limited to
8 bytes. This clause must be specified if AUDIT LOG has been specified.
The
AuditName appears in outputs of the Audit Tool.
AUDIT ELEMENTS Specifies the types of audit logging that will be done for the database. If
this clause is omitted and AUDIT LOG is specified, DATA AUDIT
ELEMENTS is implicit. The audit elements are as follows:
COMMENT permits use of the LOG COMMENT statement in the
DBEnvironment. Comments are logged to the defined
COMMENT PARTITION. If this element is not chosen,