HP 3000 Manuals HP 3000 Manuals
Creating a DBEnvironment
If you exited from ISQL, you must run ISQL again. Then, to create a new
DBEnvironment, use the START DBE NEW command at the ISQL prompt, as
follows:
isql=> START DBE 'MUSICDBE' NEW; Return
If you forget to use the semicolon, a continuation prompt appears:
>
Simply type a semicolon and press Return. After a brief interval, you
will see the ISQL prompt return. That's it! You have created a new
DBEnvironment named MUSICDBE.
Exit from ISQL as explained in the previous section. Use an operating
system command to display the files in your current group or directory.
Notice three newly created files:
* MUSICDBE.
* DBEFILE0.
* DBELOG1.
DBECon File
The first of these is the DBECon file or DBEnvironment configuration
file. This has the same name you assigned to the DBEnvironment in the
START DBE command. The DBECon file contains startup parameters for the
DBEnvironment. For complete information about startup parameters, refer
to the "DBEnvironment Configuration and Security" chapter of the
ALLBASE/SQL Database Administration Guide.
DBEFile0
DBEFILE0 is a file containing the data for the SYSTEM DBEFileSet, which
contains the system catalog. (You'll examine the system catalog later.)
Log File
DBELOG1 is the log file, which records operations that modify the
database in any way. The log file is not discussed further here. For
more information, refer to the "Backup and Recovery" chapter in the
ALLBASE/SQL Database Administration Guide.
For more information on configuring a DBEnvironment, refer to the entry
for START DBE NEW in the "SQL Commands" chapter of the ALLBASE/SQL
Reference Manual. This entry describes all the default configuration
values used in creating MUSICDBE.