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.

Discover more from Srinimf

Subscribe now to keep reading and get access to the full archive.

Continue reading