Hi,

How to move container from one dir to another ?

thanks
Vilius

DB2RELOCATEDB command. - Refer documentation.

HTH

Sathyaram

...or perform a redirected restore.

Add containers (large enough to hold everything) on the new location and wait for the "rebalance" to finish. 50% of your data is transferred now.
Drop the old/original containers. The next rebalance operation will transfer the remaining 50% of your data.
There is a performance impact, but the database does not have to be brought down.

What you can do is:

1) alter tablespace to add a new container of the same size (specify a different filesystem/directory) and specify "begin new stripe set" so that rebalancing doesn't kick in

2) alter tablespace to remove the original container


At the end, all data will be moved from the original container to the new container without rebalancing.