IBM Support

When will be free pages available from Rebalance process?

Technical Blog Post


Abstract

When will be free pages available from Rebalance process?

Body

We need to wait for Rebalance to complete in order to use free pages for container involved.

We can't make the Rebalanced page "free" when Rebalance is still in progress.

Example:
 
Two containers 0, 1,  each container/file size limitation is 4 extents.
 0    1
--------
 0    1
 2    3
 4    5
 6    7
 
After add two path into the storage path group, two new containers 2, 3
will be created and the new map will looks like :
 0    1    2   3
 ----------------
 0    1    2   3
 4    5    6   7
 -    -
 -    -
 
Before Rebalance is done, no new data can be written into container 2,3
as they are not ready yet.

When new data comes in during Rebalance, new strip set will be created.
In this case, most likely new containers/files can be created(one per
storage path where space is available).
 
When Rebalance is done, the new containers will remain as new strip set
starts from there.We may 'reclaim' some space back ( from previous container 1, 2 ) by
"alter tablespace reduce max". 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm13286485