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.
Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.