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
Start of changeThe 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.

End of change
YES
Start of changeSpecifies that all keys of the non-partitioned secondary indexes are sorted.End of change
NO
Specifies that only keys of the non-partitioned secondary indexes that are in the scope of the REORG are sorted.