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