STOGROUP specification description

Use the STOGROUP specification to control the order in which volumes in a STOGROUP are allocated during the execution of BMC AMI Recover. Because a STOGROUP definition in the Db2 catalog has no inherent ordering of the volumes, a STOGROUP specification with the OPTION command statement becomes necessary when you need a specific order.

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.

Related topics

OPTIONS-option-descriptions

Example-11-Recovering-using-a-change-accumulation-file

INDEP-OUTSPACE

INDEPENDENT-OUTSPACE-specification-for-IMPORT

INDEPENDENT-OUTSPACE-specification-for-MIGRATE


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).

OPTION STOGROUP PRODSG1 USEORDER (PROD01,PROD02,PROD03,PROD04)
         STOGROUP PRODSG2 USEORDER (PROD02,PROD03,PROD04,PROD01)
         STOGROUP PRODSG3 USEORDER (PROD03,PROD04,PROD01,PROD02)
         STOGROUP PRODSG4 USEORDER (PROD04,PROD01,PROD02,PROD03)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*