REORG TS NOPAD DEFAULT (REORG_TS_NOPAD_DEFAULT subsystem parameter)
Specifies the default setting for the NOPAD option of the UNLOAD EXTERNAL specification or the DISCARD specification of the REORG TABLESPACE utility. In other words, the setting to use for a REORG TABLESPACE statement that does not explicitly specify a NOPAD option.
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| Update: | option 37 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM REORG_TS_NOPAD_DEFAULT |
When the REORG TABLESPACE utility is run with DISCARD or UNLOAD EXTERNAL, the NOPAD option specifies whether variable-length columns in unloaded or discarded records occupy the actual data length without additional padding. The unloaded records can have varying lengths. The REORG_TS_NOPAD_DEFAULT subsystem parameter indicates whether the NOPAD option is NO or YES by default when it is omitted from the utility control statement. Valid options for the REORG_TS_NOPAD_DEFAULT subsystem parameter are:
- YES
- Specifies that, by default, the variable-length columns in the unloaded or discarded records occupy the actual data length without additional padding.
- NO
- Specifies that, by default, REORG processing pads variable-length columns in the unloaded or discarded records to their maximum length; the unloaded or discarded records have equal lengths for each table.