Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

Partition rebalancing

REORG PLUS supports partition rebalancing in the following ways:

  • REORG PLUS reorganizes partitions that have had the values of their partition keys previously altered and are now in REORG pending (REORP) status.
  • REORG PLUS reorganizes logically contiguous partitions for any type of SHRLEVEL table space reorganization where you alter the partition’s limit key during the reorganization by using one of the following methods:

    • Providing a DDLIN data set (defined by the DDLIN DD statement)

      For more information, see DDLIN-data-set-restrictions-and-considerations.

    • Specifying the REBALANCE command option

      When you specify the REBALANCE command option, REORG PLUS automatically rebalances partitions during the reorganization. By specifying REBALANCE, you can have REORG PLUS determine the limit keys for you. For more information about this option, see REBALANCE.

The following topics describe partition rebalancing:

Related topics

Rebalancing-partitions

Operational-considerations

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*