rebalance tbspace

Mathew_paul · #1 (**permalink**) 10-13-09, 00:35

hi all

db2 V 8 on aix
i have dms tablespaces with 25 containers size of 50 gb (tablespacesize)
there is no much data it would be of abt 10 gb
when i droping the containers its going into rebalancing
is there a way to avoid it
regds
Paul

dr_te_z · #2 (**permalink**) 10-13-09, 02:09

When you drop 1 or more containers it goes into rebalance (gotta move the data out first, right?)
When you shrink the sizes of all containers no rebalance tales place. Mind the HWM when you determine the new size.

n_i · #3 (**permalink**) 10-13-09, 07:25

If you drop all containers that need to be dropped at once, using a single ALTER TABLESPACE command, there will be only one rebalance operation.

Internet Services

Web Development

Digital Marketing

Consumer Tech