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.
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.
For new databases, table spaces are created as automatic storage by default. Use the CREATE TABLESPACE statement to create new automatic storage table spaces.
ALTER TABLESPACE tbsp_name MANAGED BY AUTOMATIC STORAGE [USING STOGROUP stogroup-name];
ALTER TABLESPACE tbsp_name REBALANCE;