DB2 - SQL Alter Storage Group Statement

Following syntax is used for altering the storage group.

ALTER STOGROUP storage-group-name
      ADD VOLUMES(volume-id) |
      REMOVE VOLUMES(volume-id)
      DATACLAS dc-name
      MGMTCLAS mc-name
      STORCLAS sc-name

Syntax Explanation:

• ADD VOLUMES: Adds volumes to the storage group.

• REMOVE VOLUMES: Removes volumes from the storage group.

Example 1:

Alter storage group DSN8G910. Add volumes DSNV04 and DSNV05.

ALTER STOGROUP DSN8G910
      ADD VOLUMES (DSNV04,DSNV05);

Example 2:

Alter storage group DSN8G910. Remove volumes DSNV04 and DSNV05.

ALTER STOGROUP DSN8G910 TO REMOVE VOLUMES (DSNV04,DSNV05);

If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!