ALLBASE/SQL Reference Manual (36216-90216)

60 Chapter2
Using ALLBASE/SQL
Creating DBEnvironments
Creating DBEnvironments
Before you can create a database, you must first configure a DBEnvironment. You use the
START DBE NEW statement, optionally specifying startup parameters to override those
assigned by default. You can use parameters to specify the following information:
• Multiuser or single-user mode
• Single, dual, or audit logging
• Number of page and log buffers
• Maximum number of partitions and concurrent transactions
• Number of runtime control blocks
• Timeout parameters
• DBEFile0 characteristics
• DBELog1 and DBELog2 characteristics
The DBEnvironment name, SomeDBE for example, is specified within single quotation
marks in the START DBE NEW statement:
START DBE 'SomeDBE' MULTI NEW
This statement configures a DBEnvironment named SomeDBE in your group and account.
This DBEnvironment contains the following files:
• A DBECon file named SomeDBE
• A DBEFile named DBEFile0, which is associated with a DBEFileSet named SYSTEM
• DBEFile0, containing a system catalog
• A single log file named DBELog1
The startup parameter
MULTI makes this DBEnvironment accessible in multiuser mode by
default.
The DBECon file stores the startup parameters defined by the START DBE NEW statement.
For more information on startup parameters, refer to START DBE NEW in Chapter 12 , “SQL
Statements S - Z.”
Once a DBEnvironment exists, one or more databases can be created in it. Because
databases are collections of tables and views, databases are created by defining tables and
views. The definition of tables and views is discussed later in this chapter in “Defining
How Data is Stored and Retrieved.”
Specifying a Native Language Parameter
You can specify a native language parameter in creating a DBEnvironment. Use the
LANG =
LanguageName option in the START DBE NEW statement to specify a native
language other than NATIVE 3000, as in the following example:
START DBE 'SomeDBE' NEW LANG = JAPANESE;