PAD INDEXES BY DEFAULT field (PADIX subsystem parameter)
The PADIX subsystem parameter determines whether new indexes are to be padded by default.
Acceptable values: | NO, YES |
---|---|
Default: | NO |
Update: | option 15 on panel DSNTIPB |
DSNZPxxx: | DSN6SPRM.PADIX |
- NO
- New indexes will not be padded unless the PADDED option is specified on the CREATE INDEX statement.
- YES
- New indexes will be padded unless the NOT PADDED option is specified on the CREATE INDEX statement.
This parameter affects only indexes that have at least one varying-length column.