DB2 Version 10.1 for Linux, UNIX, and Windows

Renaming storage groups

Use the RENAME STOGROUP statement to rename a storage group.

Procedure

Use the following statement to rename a storage group:

   RENAME STOGROUP sg_hot TO sg_warm

where sg_warm is the new name of the storage group.

Example

When the first storage group is created at database creation time, the default storage group name is IBMSTOGROUP. You can use the following statement to change the designated default name:

   RENAME STOGROUP IBMSTOGROUP TO DEFAULT_SG

where DEFAULT_SG is the new default name of the storage group.