ALLBASE/SQL Reference Manual (36216-90216)

560 Chapter12
SQL Statements S - Z
START DBE NEW
SQL Syntax — DBELogDefinition
LOG DBEFILE DBELog1ID [AND DBELog2ID ]
WITH PAGES =
DBELogSize ,
NAME = '
SystemFileName2 ' [AND ' SystemFileName3 ']
Parameters — DBELogDefinition
LOG DBEFILE describes the two log files if the DUAL LOG option is specified, or a single
log file otherwise. If you give information for two log files but omit the
DUAL LOG option, the information for the second log file is ignored.
DBELog1ID and DBELog2ID are the basic names identifying the log files.
DBELogSize specifies the number of 512-byte pages in one log file. If dual logging is
used, both logs must be the same size. The DBE log size should be at least
250 pages and no greater than 524,287 pages. The default is 250. If you
choose an odd number of pages, the number is rounded up to an even
number.
SystemFileName2 and SystemFileName3 identify how the logs are known to HP-UX.
The logs are created relative to the directory specified in the
DBEnvironment name parameter unless an absolute path name is
specified.
Description
• When you issue this statement, ALLBASE/SQL creates a DBECon file with the same
name as the
DBEnvironmentName .
• 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