SYSSTOGROUP catalog table
The SYSSTOGROUP table contains one row for each storage group. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| NAME | VARCHAR(128)
NOT NULL |
Name of the storage group. | G |
| CREATOR | VARCHAR(128)
NOT NULL |
Authorization ID of the owner of the storage group. | G |
| VCATNAME | VARCHAR(24)
NOT NULL |
Name of the integrated catalog facility catalog. | G |
| VPASSWORD | VARCHAR(24)
NOT NULL |
Not used. | N |
| SPACE | INTEGER
NOT NULL |
Number of kilobytes of DASD storage allocated to the storage group as determined by the last execution of the STOSPACE utility. | G |
| SPCDATE | CHAR(5)
NOT NULL |
Not used. | N |
| 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 |
| CREATEDBY | VARCHAR(128)
NOT NULL WITH DEFAULT |
Primary authorization ID of the user who created the storage group. | G |
| STATSTIME | TIMESTAMP
NOT NULL WITH DEFAULT |
If the STOSPACE utility was executed for the storage group, date and time when STOSPACE was last executed. | G |
| CREATEDTS | TIMESTAMP
NOT NULL WITH DEFAULT |
Time when the CREATE statement was executed for the storage group. | G |
| ALTEREDTS | TIMESTAMP
NOT NULL WITH DEFAULT |
Time when the most recent ALTER STOGROUP statement was executed for the storage group. If no ALTER STOGROUP statement has been applied, ALTEREDTS has the value of CREATEDTS. | G |
| SPACEF | FLOAT
NOT NULL WITH DEFAULT |
Kilobytes of DASD storage for the storage group. The value is -1 if statistics have not been gathered. This is an updatable column. | G |
| DATACLAS | VARCHAR(24)
NOT NULL |
Name of the SMS data class. Blank if data class is not used. | G |
| MGMTCLAS | VARCHAR(24)
NOT NULL |
Name of the SMS management class. Blank if management class is not used. | G |
| STORCLAS | VARCHAR(24)
NOT NULL |
Name of the SMS storage class. Blank if storage class is not used. | G |
| CREATORTYPE | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of creator:
|
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 |
 FL 502 KEYLABEL |
VARCHAR(192) NOT NULL WITH DEFAULT |
The default key label that is used for encrypting all the table spaces and index
spaces using the storage group. Otherwise the value is an empty string |
|