Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Rebalancing partitions

Use the following procedure to rebalance partitions in REORG PLUS.

Related topic

Partition-rebalancing

To rebalance partitions

  1. Either include a DDLIN data set in your JCL or specify REBALANCE on the REORG command.
  2. Include an 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 an 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.

 

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