Storage partitions

A database storage partition is the location where a database object is stored on a disk. Database storage partitions are called table spaces in DB2® and Oracle, and called file groups in SQL Server.

When a database is created, the database administrator configures the DBSTORAGEPARTITION domain in the Domains application to include a list of available table spaces where objects are stored. When you create an object as a table, you specify the storage partition from this list of available table spaces.

In IBM® DB2, the database or system can manage table spaces:

If the database manages table spaces, indexes can be different from the table.
If the system manages table spaces, indexes must be the same as the table.

The database and the system cannot manage table spaces simultaneously; you must choose one or the other.

Feedback