How Do I Create a DBEnvironment?

You use the SQL START DBE NEW statement to create a DBEnvironment:

   START DBE 'DBEName' NEW

Once the DBEnvironment exists, you can create databases within it.

The START DBE NEW statement lets you supply options to specify many of the run-time characteristics of the DBEnvironment. The simple form of the statement shown above uses default values for these options. The defaults are described in detail in the ALLBASE/SQL Database Administration Guide chapter entitled "DBEnvironment Configuration and Security."

When you create a DBEnvironment, you are granted the broadest kind of authority--permission in an ALLBASE/SQL DBEnvironment--to create and remove objects. This authority is known as DBA (database administrator) authority.