There are two types of table spaces that can exist in a database: Database-managed space (DMS), and system-managed space (SMS).
DMS table spaces are managed by the database manager. and are designed and tuned to meet its requirements.
The DMS table space definition includes a list of files (or devices) into which the database data is stored in its DMS table space format.
You can add pre-allocated files (or devices) to an existing DMS table space in order to increase its storage capacity. The database manager automatically rebalances existing data in all the containers belonging to that table space.
DMS and SMS table spaces can coexist in the same database.
[ Top of Page | Table of Contents | Glossary | Index ]