ALLBASE/SQL Reference Manual (36216-90216)
562 Chapter12
SQL Statements S - Z
START DBE NEW
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. If no COMMENT PARTITION is specified,
DEFAULT is assumed. The DEFAULT PARTITION or the COMMENT PARTITION
can be specified as NONE.
• Use of the clause ALL AUDIT ELEMENTS implies specification of all of the audit
elements.
• Additional log files should be added using the SQLUtil ADDLOG command.
Authorization
No authorization is needed for using the START DBE NEW statement. hpdb must have write
permission in the target directory for all the files the START DBE NEW statement creates.
Example
The DBEnvironment for the sample database is a multiuser DBEnvironment in which as
many as five transactions can execute concurrently. The DBEnvironment is initially
configured for two rollback logs and a DBEFile0 residing in PartsF0. The number of
runtime control pages to be used is 500. By default, autostart mode is set to ON.
START DBE '../sampledb/PartsDBE' MULTI NEW
DUAL LOG,
TRANSACTION = 5,
DBEFILE0 DBEFILE PartsDBE0
WITH PAGES = 150, NAME = 'PartsF0',
LOG DBEFILE PartsDBELog1 AND PartsDBELog2
WITH PAGES = 256, NAME = 'PartsLg1' AND 'PartsLg2',
RUN BLOCK = 500
The DBEnvironment has all the above parameters listed and it is enabled for audit
logging. All DML and DDL changes in the DBEnvironment are subject to audit logging
since all audit elements are selected. Up to 20 partitions can coexist in this
DBEnvironment, allowing for 14 data partitions in addition to the other elements'
partitions. The log files should be made large enough for the added audit log records.
START DBE '../sampledb/PartsDBE' MULTI NEW
DUAL AUDIT LOG,
TRANSACTION = 5,
RUN BLOCK = 500,
AUDIT NAME = 'PrtsDBE1',
DEFAULT PARTITION = 1,
COMMENT PARTITION = 2,
MAXPARTITIONS = 20,
ALL AUDIT ELEMENTS,
DBEFILE0 DBEFILE PartsDBE0
WITH PAGES = 150, NAME = 'PartsF0',
LOG DBEFILE PartsDBELog1 AND PartsDBELog2
WITH PAGES = 1000, NAME = 'PartsLg1' AND 'PartsLg2'