ADD DBEFILE [ ALLBASE/SQL Database Administration Guide ] MPE/iX 5.5 Documentation
ALLBASE/SQL Database Administration Guide
ADD DBEFILE
Associates a DBEFILE with the SYSTEM DBEFileSet.
Scope
SQLMigrate Only
SQLMigrate Syntax
ADD DBEFILE DBEFileName TO DBEFILESET SYSTEM;
Parameters
DBEFileName is the name of a DBEFile previously defined and
created by the CREATE DBEFILE command.
Description
* 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.
* Note that the DBEFile can be added only 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,[REV BEG] 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.[REV END]
Example
SQLMIGRATE=> create dbefile ThisDBEFile with pages=1000, name='ThisFile';
SQLMIGRATE=> add dbefile ThisDBEFile to dbefileset SYSTEM;
MPE/iX 5.5 Documentation