Can somebody explain to be the concept of rebalancing (DB2 for LUW). It sounds like redistributing data across the available containers.
I have a DMS TS S1, using container file F1.
F1 is 600 MB (as per disk utilization)
I add two more containers F2 AND F3 (same size as F1)
based on my interpretation of the term rebalancing, after rebalancing, I expect to see the usage as
file F1 is 200MB
file F2 is 200MB
file F3 is 200MB
However, I don't see what I thought I might see.
Could someone please explain this concept of rebalancing to me ? Is this something specific to the LUW world, or does it also exist in the z/OS world ?
when you add containers F2 ,F3 (600M) to TS S1, OS will alloc file ,its sizewill be 600M as you see.
rebalance means DB2 will move Extents from f1 to f2,f3,in order to improve IO performance. F1 may be not fully used before rebalance,for example , it is only used 300M,other 300M space is empty. After rebalance , F1 will be used 100M by DB2,other 500M space is not used. F2,F3 too.
But when we see F1,F2,F3 from OS, it still is 600M.