If you exited from ISQL, you must run ISQL again. Then, to create a new DBEnvironment, use the START DBE NEW statement 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:
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 statement. 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 Statements" chapter of the ALLBASE/SQL Reference Manual. This entry describes all the default configuration values used in creating MUSICDBE.
