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.

Rebalancing partitions

Use the following procedure to rebalance partitions in REORG PLUS.

To rebalance partitions

  1. Either include a DDLIN data set in your JCL or specify REBALANCE on the REORG command.
  2. Include a SYSARC data set, if needed.If the partitioned table space is LARGE (either by definition or by default) or defined with DSSIZE, and the last partition is in REORP status, REORG PLUS requires a SYSARC data set. Any rows that REORG PLUS discards because their primary key is greater than the newly designated limit key for the highest-numbered partition are written to the SYSARC data set. You can allocate the SYSARC data set in JCL or have REORG PLUS dynamically allocate it for you.
  3. (optional) Include a DDLOUT DD statement in your JCL if you want to keep a record of the ALTER statements for the limit-key updates that REORG PLUS makes.
  4. Specify COPY YES on the REORG command.
  5. Include all contiguous partitions in the same reorganization that are in REORP status or that you want to rebalance.For example, if the following set of conditions exists, you must reorganize partitions 2 through 6 in the same reorganization job:
    • You are reorganizing a table space with seven partitions.
    • Only partitions 2 and 3 are in REORP status.
    • You want to alter the limit keys on partitions 4 and 5, but not the remaining partitions.
  6. Make any necessary changes to your job based on the information in Partition-rebalancing.

Related topic

Partition-rebalancing

 

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