REORG PART SORT NPSI field (REORG_PART_SORT_NPSI subsystem parameter)
The REORG_PART_SORT_NPSI subsystem parameter specifies whether the REORG TABLESPACE PART utility decides to sort all of the keys of a non-partitioned secondary index. The setting is ignored for a REORG that is not part-level or without non-partitioned secondary indexes.
| Acceptable values: | AUTO, NO, YES |
|---|---|
| Default: | AUTO |
| Update: | option 37 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM REORG_PART_SORT_NPSI |
- AUTO
- The utility determines whether to sort all NPSI keys or only keys in the scope of the REORG operation.
The decision is based on many factors, including a projection of the estimated elapsed time and CPU performance savings of sorting all NPSI keys being processed. However, the actual performance varies depending on the specific scenario, and CPU and elapsed time reductions are not always guaranteed.
- YES
- Specifies that all keys of the non-partitioned secondary indexes are sorted.
- NO
- Specifies that only keys of the non-partitioned secondary indexes that are in the scope of the REORG are sorted.