IBM Books

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.

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

[ DB2 List of Books | Search the DB2 Books ]