REORG enhancements
Db2 12 provides enhancements to the REORG utility.
Db2 12 introduces the following
improvements to REORG:
- Improved FlashCopy® management
- A REORG with only a FlashCopy inline image copy causes the REORG to fail if the FlashCopy itself fails.
- Improved partition-level partition-by-growth REORGs
- Supports creation of a new PBG partition for overflow rows during a partition-level REORG.
- Prevention of COPY-pending on a LOB table space during REORG of partition-by-growth table spaces
- Avoids leaving COPY pending on LOB table spaces of new partition-by-growth partitions grown during the log phase of REORG.
- REORG-level management of delete of PBG partitions
- Adds a new keyword, DROP_PART, for REORG empty partition-by-growth partition pruning when ZPARM alteration is not feasible.
- Support for the new COMPRESSRATIO catalog column
- Adds to LOAD, REORG, and RUNSTATS the ability to gather average compression ratio at the record level instead of the page saved level.
- Additional offload to zIIP
- The RELOAD phase can now be offloaded to zIIP specialty engines.
- New mapping table format support
- New format supports 7-byte RIDs needed with partition-by-range table spaces with relative page numbering.
- REORG against RO pagesets
- You can run REORG with any SHRLEVEL against any RO table space and indexes.
- Display of claimer information
- You can display claimer information on each drain failure, not just last retry.