Create Table Space -- Fields and controls

" " Table space name
" " Type of table space
" " Space management
" " For partitioned database environments only. Nodegroup
" " Container list
" " For partitioned database environments only. Nodes contain Exceptions
" " For partitioned database environments only. List
" " Comment
" " OK
" " Advanced
" " Show SQL
" " Cancel



" " Table space name

Type a unique name for the table space that you're creating. This name:

" " Type of table space

Select one radio button to specify 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. All long table spaces must be created as database managed space (DMS) table spaces.

System Temporary
The system temporary table space stores temporary tables. A system temporary table space is created automatically when a database is created. At least one temporary table space must exist in every database.

User Temporary
The user temporary table space stores user-defined temporary tables. User temporary table spaces are not automatically created during database creation. At least one temporary table space must exist in every database.

" " Space management

Select one radio button to specify 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.

The operating system stores the database data into space that is assigned when a table space is created. The table space definition includes a list of one or more of the directory paths where this data is stored.

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.

The DMS table space definition includes a list of files or devices that store the database data in DMS table space format.

You can add containers to an existing DMS table space to increase its storage capacity. The database manager automatically rebalances existing data in all containers that belong to the table space.

DMS table spaces and SMS table spaces can coexist in the same database.

" " Nodegroup

This box displays the nodegroup in which the table space will be created. To specify a different nodegroup click on the arrow, and select a different nodegroup.

" " Container List

This list shows the containers that are currently being used to store the table space. For SMS containers, the list shows the path of the container. For DMS containers, the list shows the full path, the type, and the size of the container.

Use the buttons to add more containers, change an existing container, or remove a container.

Add
Opens the Add Container window, where you can specify the path and, if applicable, the type and size of the container.

Change
Opens the Change Container window, where you can specify the path and, if applicable, the type and size of the selected container.

Remove
Removes the selected container from this table space.

" " Nodes contain Exceptions

Select this check box to indicate that the characteristics of the selected container will have different characteristics on one or more nodes.

" " List

Click on this push button to open the List Exceptions window, which you use to specify the nodes on which the selected container will have different characteristics.

" " Comment

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

" " Advanced

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