STOGROUP specification description
Allocations for table spaces and index spaces are attempted on volumes in the order specified in the USEORDER clause. Volumes in the Db2 storage group that are not included in the USEORDER clause are used after those explicitly requested and are used in the order that they are retrieved from SYSIBM.SYSVOLUMES.
You can include more than one STOGROUP specification in one OPTION command statement.
If you do not use the STOGROUP specification, the volumes are allocated in the order that they are retrieved from SYSIBM.SYSVOLUMES. For more information, see Storage group-defined data sets.
Option | Description |
---|---|
STOGROUP storageGroupName | STOGROUP storageGroupNname specifies the name of a Db2 storage group. storageGroupName must be the name of a storage group that is found in SYSIBM.SYSSTOGROUP. If the storage group is not found in SYSIBM.SYSSTOGROUP, a warning is issued during analysis. If a valid storage group is included in the STOGROUP specification but is not referenced by any of the spaces being recovered, a warning is issued. |
USEORDER volumeSerialNumber | Left and right parentheses are required around the list. Each volumeSerialNumber in the list must be found in the SYSIBM.SYSVOLUMES associated with storageGroupName. If a volume serial number that is specified is not found in SYSIBM.SYSVOLUMES, a fatal error occurs during analysis. In the following OPTION command statement, all table spaces implicated in the recovery that use STOGROUP PRODSG1 will try to find space on the volumes in the order PROD01, PROD02, PROD03, and PROD04. Table spaces that use STOGROUP PRODSG2 will use volumes PROD02, PROD03, PROD04, and PROD01 (in that order).
|
Comments
Log in or register to comment.