ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 565
SQL Statements S - Z
START DBE NEWLOG
ControlBlockPages specifies the number of runtime control blocks to be allocated. Any
value specified here temporarily overrides the value specified 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.
DefaultPartitionNumber must be in the range 1 and
32767. If NONE is specified, tables assigned to the DEFAULTPARTITION
do not generate audit log records. no tables in the DBEnvironment are
prepared for audit logging and no operation done on these tables is logged.
See the CREATE TABLE and ALTER TABLE statements for information on
assigning a partition for a table.
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.
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
(except the DATA audit 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 for more
partitions or audit elements.
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 follow:
COMMENT This permits use of the LOG COMMENT statement in the
DBEnvironment. Comments are logged to the defined
COMMENT PARTITION. If this element is not chosen,
the LOG COMMENT statement returns an error.
DATA This is the default element. It causes audit log records to
be generated for any data operations (INSERT, UPDATE,