PREVENT ALTER LIMITKEY field (PREVENT_ALTERTB_LIMITKEY subsystem parameter)
PREVENT_ALTERTB_LIMITKEY determines whether Db2 disallows altering the limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces. This alter operation places the table space in REORG-pending (REORP) restrictive status, and the data is unavailable until the affected partitions are reorganized. Use PREVENT_ALTERTB_LIMITKEY to avoid this data unavailability.
| Acceptable values: | NO, YES |
|---|---|
| Default: | NO |
| Update: | option 16 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM PREVENT_ALTERTB_LIMITKEY |
- NO
- Specifies that you can alter a limit key by using an ALTER TABLE statement for index-controlled
partitioned table spaces.
NO is the default.
- YES
- Specifies that altering a limit key by using an ALTER TABLE statement for index-controlled partitioned table spaces is not permitted. An ALTER TABLE statement must not attempt to alter the limit key for an index-controlled partitioned table.