Storing a table in a Separate DBSpace

A dbspace is a logical collection of storage space. By default, a table is stored in the same dbspace in which the current database resides. You can store a table in a separate dbspace from the current database.

To locate a table in a separate dbspace

1. In the Table Editor, open the table that you want to store in a separate dbspace.
2. Click the General tab and select In Separate DBSpace from the Table Location n list box.
3. Select the appropriate dbspace from the DBSpace n list box.
4. Choose Table->Execute to save the table in the database.