 |
» |
|
|
|
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;
|
|
