From DBArtisan
Jump to: navigation, search

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

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.


Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies.


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.