Creating a storage group

Authorities and privileges

To define a storage group:

1. Open the create storage group window.

2. Enter a valid unique name for your storage group. There is a system default storage group, SYSDEFLT, defined when DB2 is installed. If you are authorized, and do not take specific steps to manage your own storage, you can still define tables, indexes, table spaces, and databases; DB2 uses SYSDEFLT to allocate the necessary auxiliary storage. You cannot have 2 storage group names that are the same within the same subsystem.

3. Select the volume type as SMS or DMS to manage your storage groups. When you have completed this window, DB2 does not check the existence of the volumes that you have listed or determine the types of devices they identify until the storage group is later used to allocate data sets. At that time, DB2 passes the list of volumes in the order you specified here to Data Facilities (DFSMSdfp), which does the data set allocation.
   • DMS volumes:
     • When DMS volumes are specified, the window to display the volumes is enabled.

     • Click the Add or Change push buttons to to add or modify volume names.

     • Click the Remove push button to delete a DMS volume from the list.

   • SMS volumes:
     • SMS is the DFSMShsm (Data Facility Hierarchical Storage Manager).

     • Type the maximum number of volumes to allocate. The number is only applicable to SMS volumes.

4. Enter a catalog name. For both user-managed and DB2-managed data sets, you need at least one integrated catalog facility catalog, either user or master, created with the integrated catalog facility. You must identify the integrated catalog facility catalog (the "integrated catalog") when you create a storage group.

5. Optional: Enter an MVS or VSAM password to be used to access this storage group. Protect your SMS volumes with RACF passwords.

6. Click on Show SQL to show the SQL statement that is generated.

7. Click OK to commit the changes.

   
   

Related information:

Information about SYSDEFLT, as with any other storage group, is kept in the catalog tables SYSIBM.SYSSTOGROUP and SYSIBM.SYSVOLUMES.

• Storage group concepts

• naming conventions

Tips:

If the volumes you name are not mounted, or are not all of the same device type, a dynamic allocation error occurs when you try to create a table space or index.