DB2 Version 10.1 for Linux, UNIX, and Windows

FP1: DMS permanent table spaces are deprecated

Starting with DB2® Version 10.1 Fix Pack 1, the database managed spaces (DMS) table space type is deprecated for permanent table spaces that are defined by the user.

Details

You can still specify the DMS type for temporary and catalog table spaces. Use the automatic storage table space type to create user table spaces.

In previous releases, you created DMS permanent table spaces to decide which files and devices to use for containers and to manage the space for those files and devices. However, the cost of maintenance for DMS table spaces was high.

With the introduction of automatic storage, management of table spaces was simplified. IBM® continues to invest and develop in automatic storage.

Resolution

For new databases, table spaces are created as automatic storage by default. Use the CREATE TABLESPACE statement to create new automatic storage table spaces.

For existing DMS permanent table spaces, start converting them to automatic storage table spaces before they become discontinued. Use the ALTER TABLESPACE statement to convert DMS table spaces to automatic storage table spaces as follows:

ALTER TABLESPACE tbsp_name MANAGED BY AUTOMATIC STORAGE [USING STOGROUP stogroup-name];
ALTER TABLESPACE tbsp_name REBALANCE;