Does anybody know how one can speculate that how long will it take to rebalance the data if one or more containers are added to exisiting DMS tablespace?

UDB V8 FP 3 on windows

dollar

I am thinking that this might depend on the volume of data in the table which has the container addition. You could export the data and load it to a new tablespace with additional containers without impacting your users. Ensure the table is in the same schema and name it slightly different, like _new. Then rename the table when you're done loading. For an MPP db this can be done in parallel and can be fairly optimized, again, depending on the volume of data.

If you have time, read

http://publib.boulder.ibm.com/infoce...n/c0008087.htm

this topic may not give a definitive answer on time, but very clearly explains how rebalancing happens ...

cheers
Sathyaram