CREATE DBEFILE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
CREATE DBEFILE
Defines and creates a DBEFile of TYPE MIXED.
Scope
SQLMigrate Only
SQLMigrate Syntax
CREATE DBEFILE DBEFileName WITH PAGES = DBEFileSize, NAME
='SystemFileName';
Parameters
DBEFileName is the name to be assigned to the new DBEFile. Two
DBEFiles in one DBEnvironment cannot have the same
name. The maximum length for the DBEFile name is
20 bytes.
DBEFileSize specifies the number of 4096-byte pages in the new
DBEFile.
SystemFileName identifies how the DBEFile is known to MPE. The
file resides in the same group and account as the
DBECon file.
Description
* When a DBEFile is created through SQLMigrate, the TYPE is MIXED.
MIXED means that data and index pages can be stored in the new
DBEFile.
* When adding space to the SYSTEM DBEFileset, the first step is to
CREATE a new DBEFile. The second step is to add the DBEFile to
the SYSTEM DBEFileSet.
* When this command is executed, you are modifying the
DBEnvironment. Whenever you modify the DBEnvironment with the
CREATE DBEFILE, ADD DBEFILE, or MIGRATE commands, a START DBE
NEWLOG statement must be executed before you will be able to
connect to the DBEnvironment. The MIGRATE command automatically
executes a START DBE NEWLOG statement unless a SET NEWLOG OFF
command has been issued.
* Before using this command, you must issue either a PREVIEW or SHOW
'DBEnvironmentName' VERSION command to indicate which
DBEnvironment is to receive the new DBEFile.
* After using this command, use the ADD DBEFILE command to add the
newly created DBEFile to the SYSTEM DBEFileSet.
Example
SQLMIGRATE=> create dbefile ThisDBEFile with pages = 5, name ='ThisFile';
SQLMIGRATE=> add dbefile ThisDBEFile to dbefileset SYSTEM;
MPE/iX 5.5 Documentation