DB2 - SQL Create Storage Group Statement

Following syntax is used for creating storage group:

CREATE STOGROUP storage-group-name
    VOLUMES (volume-id,…) or VOLUMES (*)
    VCAT catalog-name
    DATACLAS dc-name
    MGMTCLAS mc-name
    STORCLAS sc-name

Syntax Explanation:

• VOLUMES: Defines the volumes of the storage group.

• (*) indicates that SMS (Storage Management Subsystem) will manage the volumes to be used.

• VCAT: Identifies the integrated catalog facility catalog for the storage group.

• DATACLAS: Identifies the name of the SMS data class to associate with the storage group.

• MGMTCLAS: Identifies the name of the SMS management class to associate with storage group.

• STORCLAS: Identifies the name of the SMS storage class to associate with the storage group.

Create a storage group, DSN8G910, of volumes ABC005 and DEF008. DSNCAT is the integrated catalog facility catalog name.

CREATE STOGROUP DSN8G910
    VOLUMES (ABC005,DEF008)
    VCAT DSNCAT;

If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!