IBM Db2 11.1 Certification Guide

Altering storage groups

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

• OVERHEAD
• DEVICE READ RATE
• DATA TAG

You can also add or remove storage paths; if you want to add a new storage path to an existing storage group, execute the following command:

ALTER STOGROUP SG_HOT ADD '/data/hot_fs2';
ALTER TABLESPACE Q4_2014 REBALANCE;  

If you want to drop a storage path, execute the following command:

ALTER STOGROUP SG_HOT DROP '/data/hot_fs2';
ALTER TABLESPACE Q4_2014 REBALANCE;