Monitoring a table space rebalance operation

You can use the MON_GET_REBALANCE_STATUS table function to monitor the progress of rebalance operations on a database.

About this task

This procedure returns data for a table space only if a rebalance operation is in progress. Otherwise, no data is returned.

Procedure

To monitor a table space rebalance operation:

Issue the MON_GET_REBALANCE_STATUS table function with the tbsp_name and dbpartitionnum parameters:

select 
   varchar(tbsp_name, 30) as tbsp_name, 
   dbpartitionnum, 
   member, 
   rebalancer_mode, 
   rebalancer_status, 
   rebalancer_extents_remaining, 
   rebalancer_extents_processed, 
   rebalancer_start_time 
from table(mon_get_rebalance_status(NULL,-2)) as t

Results

This output is typical of the output for monitoring the progress of a table space rebalance operation:

TBSP_NAME                      DBPARTITIONNUM MEMBER REBALANCER_MODE                
------------------------------ -------------- ------ ------------------------------ 
SYSCATSPACE                                 0      0 REV_REBAL                      


REBALANCER_STATUS REBALANCER_EXTENTS_REMAINING REBALANCER_EXTENTS_PROCESSED REBALANCER_START_TIME 
----------------- ---------------------------- ---------------------------- -------------------------- 
ACTIVE                                    6517                            4 2011-12-01-12.08.16.000000


  1 record(s) selected.