Online Documentation for SQL Manager for DB2

Table spaces

A Table space is an abstraction of a collection of containers into which database objects are stored. A table space provides a level of indirection between a database and the tables stored within the database.

Creating Table spaces

To create a new table space:

• select the Database | New Object... main menu item;
• select Tablespace in the Create New Object dialog;
• edit table space properties using the appropriate tabs of Tablespace Editor.

Hint: To create a new table space, you can also right-click the Tablespaces node of the DB Explorer tree and select the New Tablespace... context menu item.

Editing Table spaces

To edit an existing table space:

• select the table space for editing in the DB Explorer tree (type the first letters of the table space name for quick search);
• right-click the object and select the Edit Tablespace <tablespace_name>... context menu item, or simply double-click the table space;
• edit table space definition using the appropriate tabs of Tablespace Editor.

Dropping Table spaces

To drop a table space:

• select the table space to drop in the DB Explorer tree;
• right-click the object and select the Drop Tablespace <tablespace_name>... context menu item;
• confirm dropping in the dialog window.

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new table space;

Ctrl+O to edit the selected table space;

Shift+Del to drop the object from the database.