HP 3000 Manuals HP 3000 Manuals
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 the "SQL statements" chapter.
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;
If you want to specify the name of the DBEnvironment in a native
language, then the native language you specify in the LANG clause must be
covered by the same character set as the language designated as the
current language at the operating system level. The current language can
be different from that of the DBEnvironment. In that case, all
processing--including comparisons and sorting--will take place in
accordance with the language of the DBEnvironment, but messages will
appear in the operating-system-designated language if the appropriate
message catalog is available. Also, scanning of user input will be
in the current language. See "Native Language Support" in the
"Introduction" chapter for information about specifying a native language
as the current language.
Initial Privileges
When a DBEnvironment is configured, ALLBASE/SQL grants the following
initial privileges:
* DBECreator status. The logon name that issues the START DBE NEW
statement is the DBECreator. Users with this status can use all
the SQLUtil statements to maintain the DBEnvironment.
* DBA authority. The DBECreator is given DBA authority. When you
have DBA authority, you are authorized to use all the SQL
statements in a DBEnvironment.
Nobody other than the DBECreator can connect to or issue SQL statements
in the DBEnvironment until the DBECreator grants the appropriate
authorities.
DBA authority cannot be revoked from the DBECreator.