SYSVOLUMES catalog table

The SYSVOLUMES table contains one row for each volume of each storage group. The schema is SYSIBM.

Table 1. SYSIBM.SYSVOLUMES table column descriptions
Column name Data type Description Use
SGNAME
VARCHAR(128)
NOT NULL
 Name of the storage group. G
SGCREATOR
VARCHAR(128)
NOT NULL
 Authorization ID of the owner of the storage group.

Start of changeTo determine the type of authorization ID for the storage group creator, see the CREATORTYPE column of the SYSIBM.SYSSTOGROUP catalog table. End of change

 G
VOLID
VARCHAR(18)
NOT NULL
 Serial number of the volume or * if SMS-managed. G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead.

 G
RELCREATED
CHAR(1)
NOT NULL
 The release of Db2 that is used to create the object. Blank if created prior to Version 9. See Release dependency indicators for all other values. G