ADD DBEFILE

Associates a DBEFILE with the SYSTEM DBEFileSet.

SQLMigrate Only

ADD DBEFILE DBEFileName TO DBEFILESET SYSTEM;

DBEFileName: is the name of a DBEFile previously defined and created by the CREATE DBEFILE command.

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, 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.

   SQLMIGRATE=> create dbefile ThisDBEFile with pages=1000, name='ThisFile';

   SQLMIGRATE=> add dbefile ThisDBEFile to dbefileset SYSTEM;

Technical documentation