Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > ALTER STOGROUP

ALTER STOGROUP

The ALTER STOGROUP statement changes the specifications of an existing storage group (stogroup) defined within the current XDB Server location.

Invocation

This statement can be embedded in an application program or issued interactively.

Authorization

To execute this command, users must either be the owner of the referenced stogroup, or possess SYSADM or SYSCTRL authority for the location.

Syntax

ALTER STOGROUP stogroup-name 
    [PASSWORD password] 
    [ADD VOLUMES (volume-id[,...])] 
    [REMOVE VOLUMES (volume-id[,...])]

Parameters:

`stogroup-name`	Identifies the stogroup to be altered. The stogroup identified must exist within the currently set XDB Server location.
`volume-id`	Refers to the volume serial number of a mainframe storage volume.

Description

ALTER STOGROUP allows users to add and remove logical volume ID designations from an existing stogroup. The XDB Server also records any mainframe assigned password in the location catalog tables (DB2 mode).

PASSWORD

This option is utilized in the mainframe-DB2 environment. Any password parameter values are recorded in the catalog tables for the current XDB Server location.

ADD VOLUMES `(volume-id,...)` or ADD VOLUMES('*',...)

XDB records the volumes added to a stogroup in the catalog tables for that location. One or more volume-id numbers (corresponding to volume serial numbers) can be specified in this clause, each with a maximum of six characters (specified as an identifier or a string constant).

A volume-id must not be specified if any volume of the storage group is designated by an asterisk (*). An asterisk must not be specified if any volume of the storage group is designated by a volume-id.

You cannot add a volume that is already in the storage group unless you first remove it with REMOVE VOLUMES.

REMOVE VOLUMES `(volume-id,...)` or REMOVE VOLUMES('*',...)

XDB Server can associate up to 133 volumes with one stogroup. The REMOVE VOLUMES option removes one or more volumes (identified by volume-id) associated with the storage group. The XDB Server applies the REMOVE VOLUMES clause to the current list of stogroup volumes, before applying any ADD VOLUMES clauses.