IBM Db2 11.1 Certification Guide

Altering storage groups

You can use the ALTER STOGROUP statement to change the following storage group settings:

• OVERHEAD and DEVICE READ RATE
• DATA TAG
• Default storage group
• Add/remove storage paths

To add a new storage path to an existing storage group, you can execute the following ALTER STOGROUP statement:

  ALTER STOGROUP SG_MKTG ADD '/data/fs2/';

To strip the table spaces which were created as part of the SG_MKTG storage group, you must use the ALTER TABLESPACE statement with the REBALANCE clause; for example:

 ALTER TABLESPACE TBSP_MKTG_DATA REBALANCE;

To drop a storage path from an existing storage group, you can execute the following ALTER STOGROUP statement:

  ALTER STOGROUP SG_MKTG DROP '/data/fs2/';

You can run the ALTER TABLESPACE ...