Table spaces

This box displays the table spaces that are in the backup image that you are using to create the database. The columns are:

Table space

The name of the table space.

Management

SYSTEM for a system-managed table space (SMS) or DATABASE for a database-managed table space (DMS).

Type

The type of table space. The value can be Regular, Long, or Temporary.

Containers

The number of containers in the table space.

State

The state of the containers in the table space. The value can be:

New

All containers will be created as part of the create database operation.

Note:

If an attempt is made to overwrite an existing container, an error will occur.

Not valid

At least one container has an invalid path.

If the state of a table space is not valid, at least one of its containers has a path that will overwrite the container of another database. In this situation, you must modify the container. You can either change the container path or remove the container, then, if you want, perform an add operation to replace the deleted container with another container.

To display the container that is in the not valid state, select the table space whose state is not valid. That table space's containers will be displayed in the Container name box, and their states will also be displayed. Select the container that you want, then specify the container modification.

Changed

At least one container was modified during the current session.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]