Description: Contains one row for each volume of each storage group.
Tablespace: SYSGROUP
Indexes(Fields):
None
| Column name | Description | Data type |
|---|---|---|
| SGNAME | Name of the storage group. | NOT NULL |
| SGCREATOR | Authorization ID of the owner of the storage group. | NOT NULL |
| VOLID | Serial number of the volume or * if SMS-managed. | NOT NULL |
| IBMREQD | A value of Y indicates that the row came from the basic machine-readable material (MRM) tape. | NOT NULL |
Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).