Enabling SMS to control Db2 storage groups

Managing data sets with the Storage Management Subsystem (SMS) family of products can reduce workload for database administrators and storage administrators.

Procedure

To enable SMS to control Db2 storage groups:

  1. Issue a CREATE STOGROUP SQL statement to define a Db2 storage group.
    You can specify SMS classes when you create a storage group.
  2. Indicate how you want SMS to control the allocation of volumes in one of the following ways:
    • Specify an asterisk (*) for the VOLUMES attribute.
    • Specify the DATACLAS, MGMTCLAS, or STORCLAS keywords.

What to do next

If you use Db2 to allocate data to specific volumes, you must assign an SMS storage class with guaranteed space, and you must manage free space for each volume to prevent failures during the initial allocation and extension. Using guaranteed space reduces the benefits of SMS allocation, requires more time for space management, and can result in more space shortages. You should only use guaranteed space when space needs are relatively small and do not change.