DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
The ALTER DATABASE statement has been deprecated and might be removed in a future release. The CREATE STOGROUP or ALTER STOGROUP statements provide the same functionality as the ALTER DATABASE statement and more.
In Version 10.1, you can issue the ALTER STOGROUP statement to add or remove storage paths to any storage group. In addition, you can use this statement to change the definition and attributes of a storage group. Use the CREATE STOGROUP statement to create a new storage group and assign storage paths to it.
With the ALTER DATABASE statement, you can only add or remove storage paths to the default storage group for the database. You cannot indicate a specific storage group.
Start using the CREATE STOGROUP or ALTER STOGROUP statements to manage storage groups before the ALTER DATABASE statement becomes discontinued. Modify any scripts or application using the ALTER DATABASE statement and replace it with the CREATE STOGROUP or ALTER STOGROUP statements.
Take advantage of the new capabilities provided by the CREATE STOGROUP or ALTER STOGROUP statements to create new storage groups, set the default storage group, and change attributes of existing storage groups to improve the physical design of your database data storage.