You use CREATE STOGROUP to create a new storage group. A storage group describes either a pubset or a set of private volumes. The private volumes in a storage group must all have the same device type (see also the “ Core manual”).
The storage group D0STOGROUP always exists.
The current authorization identifier must have the special privilege CREATE STOGROUP.
CREATE STOGROUP stogroup { VOLUMES ( volume_name ,...) ON dev_type | PUBLIC }[ON catid ]
stogroup
Name of the storage group. The unqualified name of the storage group must be unique within a database. You can qualify the name of the storage group with a database name.
The current authorization identifier will own the storage group and is granted the special privilege USAGE for this storage group.
VOLUMES (volume_name,...)
The storage group is created on private volumes. volume_name is an alphanumeric literal indicating the VSN of the volumes. You can only specify each VSN once. You can specify up to 100 volumes.
All the volumes in a storage group must have the same device type.
ON dev_type
Device type of the private volumes. dev_type is an alphanumeric literal which can be specified as a string or in hexadecimal format.
PUBLIC
The storage group comprises a pubset.
ON catid
Alphanumeric literal indicating the catid.
If you specify PUBLIC, this is the catalog ID of the pubset on which the storage group is defined and on which the files are created. In the case of private volumes (VOLUMES), this is the pubset on which the files are catalogged. The files themselves are located on the specified private volumes.
ON catid omitted:
The catalog ID assigned to the BS2000 user ID under which the DBH is running is used.
When defining a storage group on a pubset, it is also possible to specify the VOLUMES (volume_name,...) ON devicetype parameters instead of the PUBLIC parameter in order to select individual volumes of a pubset. The ID under which the DBH is running has to be authorized to physically allocated on the pubset. This is not checked when the storage group is defined.
Examples
Create the storage group STOGROUP3 on a pubset.
CREATE STOGROUP stogoup3 PUBLIC
Create a new storage group STOGROUP4 with the specified private volumes. The catalog ID “P” is used to catalog the space files created on the storage group.
CREATE STOGROUP stogroup4
VOLUMES ('DY130A','DY130B','DY130C','DY130D') ON 'D3435'
ON 'P'
See also
DROP STOGROUP