Performance improvements for the REORG TABLESPACE utility
Db2 11 delivers improved performance for the REORG TABLESPACE utility with the PART option.
In Db2 11, when subsystem parameter REORG_PART_SORT_NPSI is enabled, REORG TABLESPACE PART sorts all keys of the nonpartitioned secondary indexes and builds the shadow index from the sorted keys. This improvement potentially reduces CPU time.
In addition, this version delivers potential performance improvements as the following items increase:
- The number of nonpartitioned secondary indexes on the table space
- The amount of data in the logical part of the nonpartitioned secondary indexes
- The total amount of data in the nonpartitioned secondary indexes