CREATE DBSPACE dbspace-name AS filename

The CREATE DBSPACE statement creates a new database file. When a database is created, it is composed of one file. All tables and indexes created are placed in that file. CREATE DBSPACE adds a new file to the database. This file can be on a different disk drive than the main file, which means that the database can be larger than one physical device.

For each database, there is a limit of twelve dbspaces in addition to the main file.

Each object, such as a table or index, is contained entirely within one dbspace. The IN clause of the CREATE statement specifies the dbspace into which an object is placed. Objects are put into the system database file by default. You can also specify which dbspace tables are created in by setting the default_dbspace option before you create the tables.

DBA authority.

Automatic commit. Automatic checkpoint.

• DROP DBSPACE statement
• default_dbspace option
• Strings
• Predefined dbspaces
• Additional dbspaces considerations

The following CREATE DBSPACE statement creates a dbspace called libbooks. The database file name for the dbspace is library.db, located in the c:\ directory. A subsequent CREATE TABLE statement creates a table called LibraryBooks in the libbooks dbspace.

CREATE DBSPACE libbooks
AS 'c:\\library.db';
CREATE TABLE LibraryBooks (
  title char(100),
  author char(50),
  isbn char(30),
) IN libbooks;