Adding a DBEFile to the SYSTEM DBEFileSet

Before proceeding to create tables, you should create a DBEFile and add it to the SYSTEM DBEFileSet to provide additional space for sort operations and for expansion of the DBEnvironment. Use the following statements:

   isql=> CREATE DBEFILE DBEFile1 Return

   > WITH PAGES=50, Return

   > NAME = 'DBEFILE1', TYPE = MIXED; Return

   isql=> ADD DBEFILE DBEFile1 Return

   > TO DBEFILESET SYSTEM; Return

   isql=> COMMIT WORK; Return

You can use this procedure with different DBEFile names any time you want to add space to the SYSTEM DBEFileSet.