Hi,

I am working on DB2 Version 8.1 Fixpack 15. My O/S is Solaris.

Whenever we add or delete a container the Tablespace will got to rebalancing state? Is there any way to avoid this?

Nambi

REbalancing a simple concet If you add/delete a container. It's going take some time to evenlt spreding the data/moving all the data into one contaner.

Why do you want to avoid rebalancing?

What you could consider in your case is to use an SMS or automatic storage table space and just add more storage to your logical volume/file system. Using DMS and then not wanting rebalancing defeats slightly the purpose of DMS.

I think you can also avoid rebalancing if you BEGIN NEW STRIPE SET prior to adding new the container(s). See the description of ALTER TABLESPACE for details.