Table space rebalance considerations in a DB2 High Availability Disaster Recovery (HADR) environment

You can use the ALTER TABLESPACE REBALANCE or ALTER TABLESPACE USING STOGROUP statement to start a rebalance operation on a primary database. The statement is replayed on the standby database, and a corresponding rebalance operation is started.

During the rebalance operation, you can specify the ALTER TABLESPACE statement with the REBALANCE SUSPEND clause to suspend the rebalance operation on the primary database. To resume the suspended rebalance operation, specify the ALTER TABLESPACE statement with the REBALANCE RESUME clause.

The standby database remains in active state when it replays an ALTER TABLESPACE REBALANCE SUSPEND statement. Because the rebalance is suspended on the primary database, when the standby takes over as the new primary database the rebalance operation on the new primary database is suspended and the rebalance operation on the new standby database is implicitly resumed.

When you restore a database using a split mirror as a clone database or as a standby database, any suspended rebalance operations for table spaces are automatically resumed at database startup.