Rebalance

Go Up to Available object actions by DBMS

This action lets you build and submit one or more ALTER TABLESPACE... REBALANCE statements. This creates containers on recently added storage paths and drops containers from storage paths that are in DROP PENDING state.

Platform Availability

• DB2 LUW 9.7^

Prerequisites or Setup Tasks

This object action is only available for tablespaces that meet the following criteria:

• The tablespace must use automatic storage. That is, in the Tablespace Editor, the Use Automatic Storage property is selected.For more information see Tablespaces Editor (IBM DB2 LUW).

• In the Tablespace Editor, the Type property specifies LARGE or REGULAR.

To rebalance a tablespace

1. Initiate a Rebalance action against one or more tablespaces.
2. Use the following table as a guide to understanding and modifying settings in this wizard:

Step	Settings and tasks
Action Options	Displays the tablespaces selected for this operation.
Dependencies	Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies.
Preview	Displays the DDL that will execute the object action. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.

Topics

• Drop Automatic Storage Path(s)