Use of REBALANCE in REORG Utility

The REBALANCE parameter in REORG utility is it balance the data between table space partitions.

Three major benefits of REORG utility.

  • If you run REORG utility on index table space, it improves index performance
  • If you run REORG UTILTY on table space ,it optimizes data on table space
  • If you run REORG utility on LOB table space, it removes embedded free space, and makes pages contiguous.