DB2 Version 9.7 for Linux, UNIX, and Windows

Monitoring a table space rebalance operation

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

About this task

If no rebalance operation is in progress, the rebalancer_mode monitor element will return NO_REBAL for the table space.

Procedure

To monitor a table space rebalance operation:

Issue the SNAP_GET_TBSP_PART_V91 table function with the db_name and dbpartitionnum parameters:

select 
   varchar(tbsp_name, 30) as tbsp_name, 
   dbpartitionnum, 
   rebalancer_mode, 
   rebalancer_extents_remaining, 
   rebalancer_extents_processed, 
   rebalancer_start_time 
from table(snap_get_tbsp_part_v91(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 REBALANCER_MODE                
------------------------------ -------------- ------------------------------ 
SYSCATSPACE                                 0 REV_REBAL                      


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


  1 record(s) selected.