Creating a table space

You can define a new table space to an existing database by issuing a CREATE TABLESPACE statement. This can be useful if you find that you need to add another Fast Path DEDB Area or another data set group for a HDAM or HIDAM database.

Procedure

  1. Issue an ALTER DATABASE statement to identify the database in which you plan to include the new table space.
  2. Issue a CREATE TABLESPACE statement. Ensure that you also provide the IN keyword to reference it back to the database it belongs to.
  3. Issue any ALTER TABLE statements to move any tables you wish to the new table space (data set group). Ensure that you also provide the IN keyword to reference it to the desired table space.
  4. Issue any CREATE TABLE statements for any new tables you wish to define to the new table space (data set group).
  5. Issue a COMMIT DDL statement.