DB2 Version 9.7 for Linux, UNIX, and Windows

Adding storage paths to a database enabled for automatic storage

You can add a storage path to an automatic storage database using the ALTER DATABASE statement, . If the database is not currently an automatic storage database, adding a storage path to the database will convert it to one.

About this task

When you add a storage path for a multi-partition database environment, the storage path must exist on each database partition. If the specified path does not exist on every database partition, the statement is rolled back.

To add a storage path to an existing database, issue the following ALTER DATABASE statement:

   ALTER DATABASE database-name ADD STORAGE ON storage-path

What to do next

After adding one or more storage paths to the database, you can optionally use the ALTER TABLESPACE statement to rebalance table spaces in the database so that they start to use the new storage paths immediately. Otherwise, the new storage paths will not be used until there is no room to grow within the containers on the existing storage paths.