REORG INDEX NOSYSUT1 (REORG_INDEX_NOSYSUT1 subsystem parameter)
Specifies the default setting for the NOSYSUT1 option of the REORG INDEX utility when run with SHRLEVEL REFERENCE or CHANGE. In other words, the setting to use for a REORG INDEX statement that does not explicitly specify a NOSYSUT1 option.
| Acceptable values: | |
|---|---|
| Default: | Function level 100 only: NO1 |
| Update: | option 37 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM REORG_INDEX_NOSYSUT1 |
| Data sharing scope: | Member |
| Online changeable: |  No |
Note:
- FL 500 Starting in function level 500 or higher, Db2 13 always operates as if YES is specified. That is, the NO value for the REORG_INDEX_NOSYSUT1 subsystem parameter has no effect at function level 500 or higher.
The REORG_INDEX_NOSYSUT1 subsystem parameter specifies that the REORG INDEX SHRLEVEL REFERENCE or CHANGE utility should avoid using the SYSUT1 or work data set to hold the unloaded index keys. The utility passes the unloaded keys in memory as input to the index build for this process. REORG INDEX will also use parallel sub-tasking to unload and to build the index keys in its internal processing.
The following values are supported:
- YES
- The REORG INDEX utility avoids using the SYSUT1 or specified work data set to hold the unloaded index keys, and also uses parallel sub-tasking to unload and to build the index keys. FL 500 Starting in function level 500 or higher, Db2 13 always operates as if YES is specified.
- NO
- The REORG INDEX utility uses the SYSUT1 or specified work data set to hold the unloaded index keys. The NO value for the REORG_INDEX_NOSYSUT1 subsystem parameter has no effect at function level 500 or higher.