GRANT CREATE statement

When you initialize a database, it contains one database file. This first database file is called the main file. All database objects and all data are placed, by default, in the main file. A dbspace is an additional database file that creates more space for data. A database can be held in up to 13 separate files (the main file and 12 dbspaces). Each table, together with its indexes, must be contained in a single database file. The SQL command CREATE DBSPACE adds a new file to the database.

You must have the MANAGE ANY USER privilege.

Automatic commit.

• ANSI/ISO SQL Standard

  Not in the standard.