The MON_GET_REBALANCE_STATUS table function returns the status of a rebalance operation on a table space.
None
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
TBSP_NAME DBPARTITIONNUM MEMBER REBALANCER_MODE
------------------------------ -------------- ------ ------------------------------
SYSCATSPACE 0 0 REV_REBAL
REBALANCER_STATUS REBALANCER_EXTENTS_REMAINING REBALANCER_EXTENTS_PROCESSED
----------------- ---------------------------- ----------------------------
ACTIVE 6517 4
REBALANCER_START_TIME
--------------------------
2011-12-01-12.08.16.000000
1 record(s) selected.
The MON_GET_REBALANCE_STATUS table function only returns data for a table space if a rebalance is in progress. Otherwise, no data is returned.