Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

SYS_STOGROUPS

Information on the storage groups in the database.

Column name

Data type

Contents

STOGROUP_NAME

CHAR (18)

Name of the storage group

VOLUME_NAME

CHAR (6)

VSN of the private volumes or PUBLIC

STOGROUP_OWNER

CHAR (18)

Authorization identifier that owns the storage
group

CAT_ID

VARCHAR (4)

BS2000 catalog ID

DEVICE_TYPE

VARCHAR (8)

Device type of the private volumes

NULL value for PUBLIC

ORDINAL_POSITION

SMALLINT

Sequence number of the private volumes in
the storage group;
1 for PUBLIC

Table 133: SYS_STOGROUPS view of the SYS_INFO_SCHEMA