Letting SMS manage your Db2 storage groups

Using the SMS product Data Facility Storage Management Subsystem (DFSMS) to manage your data sets can result in a reduced workload for Db2 database and storage administrators.

Procedure

Begin general-use programming interface information.To let SMS manage the storage needed for the objects that the storage group supports:

  1. Issue an ALTER STOGROUP statement.
    You can specify SMS classes when you alter a storage group.
  2. Specify ADD VOLUMES ('*') and REMOVE VOLUMES (current-vols) where current-vols is the list of the volumes that are currently assigned to the storage group.
    For example, 
    ALTER STOGROUP DSN8G910
  REMOVE VOLUMES (VOL1)
  ADD VOLUMES ('*');

Example

The following example shows how to alter a storage group to SMS-managed using the DATACLAS, MGMTCLAS, or STORCLAS keywords.
ALTER STOGROUP SGOS5001
 		MGMTCLAS REGSMMC2
		DATACLAS REGSMDC2
 		STORCLAS REGSMSC2;

What to do next

SMS manages every new data set that is created after the ALTER STOGROUP statement is executed. SMS does not manage data sets that are created before the execution of the statement. End general-use programming interface information.