Alter Table Space -- Fields and controls

Table space name

Type of table space

Space management

Container List

Comment

OK

Advanced

List All Containers

Show SQL

Cancel

Table space name

This field displays the name currently specified for the table space that you're altering. You cannot alter the table space name.

To alter another table space instead of the one you selected, click on Cancel to return to the Control Center and select another table space.

Type of table space

The selected radio button indicates the type of data that can be stored in the table space:

Regular

The table space can store every type of data, including table, long, and index data, or just index data.

Long

The table space can store long or large object (LOB) table columns.

Temporary

The table space can store temporary tables.

You cannot alter the type of table space.

Space management

The selected radio button indicates how the storage for the table space will be managed:

System

A system managed space (SMS) table space is managed by the operating system. The operating file system allocates and manages the media storage.

Database

A database managed space (DMS) table space is managed by the database manager. A DMS table space is designed and tuned to meet the requirements of the database manager.

You cannot alter the type of space management.

Container List

This list shows the containers used to store the table space.

For DMS table spaces, the list shows the full path, type and the size of the container. For DMS table spaces, you can do the following tasks:

• To add a container to the list of containers that is used to store the table space, click on Add. The Add Container window opens.

After you've added one or more containers, you can change or remove those containers only.

• To change the path or name for a container that you just added to the list, select the container and click on Change. The Change Container window opens.

• To remove a container that you just added to the list, select the container and click on Remove. The Remove Container window opens.

For SMS table spaces, you cannot change the list of containers.

Comment

Type a comment of up to 254 characters, including embedded blanks, in this box.

Advanced

Click on this push button to change the performance parameters for a table space. The Advanced window opens.

List All Containers

Click on this push button to open the List All Containers window, which you use to list the containers on a node.

Note:

This push button is only available from the Alter Table Space window.