DB2® Version 10.5 includes
online reorganization enhancements that save you time and reclaims
more space when you maintain your tables.
DB2
Version 10.5 enhances
reorganization capabilities in the following ways:
- Inplace (online) table reorganization is now supported for tables
that use adaptive compression.
- Reclaiming extents on insert time clustering (ITC) tables now
consolidates sparsely allocated blocks into a smaller number of blocks.
This consolidation is done before empty extents are freed.
- In DB2 Cancun
Release 10.5.0.4 and
later fix packs, inplace (online) table reorganization is now supported
in a DB2 pureScale® environment.