IBM Db2 11.1 Certification Guide

Dropping storage groups

You can use the DROP STOGROUP statement to drop an existing storage group from the database using the following command:

  DROP STOGROUP TBSP_MKTG;

A few things to remember before dropping a storage group are as follows:

• You cannot drop a DEFAULT storage group. For example, you may have two storage groups, such as:

    CREATE STOGROUP SG_MKTG_DATA1 ON '/data/fs1/' OVERHEAD 0.8 DEVICE READ RATE 512 DATA TAG 1 SET AS DEFAULT;
    CREATE STOGROUP SG_MKTG_DATA2 ON '/data/fs2/' OVERHEAD 0.8 DEVICE READ RATE 512 DATA TAG 2;

• If you want to drop SG_MKTG_DATA1, you have to change the DEFAULT storage group from SG_MKTG_DATA1 to SG_MKTG_DATA2 using the statements shown here:

    ALTER STOGROUP SG_MKTG_DATA2 SET AS DEFAULT;
    DROP STOGROUP ...