PREVENT_NEW_IXCTRL_PART in macro DSN6SPRM
The PREVENT_NEW_IXCTRL_PART subsystem parameter determines whether Db2 disallows the creation of new index-controlled partitioned tables. This subsystem parameter ensures that new partitioned tables use table-controlled partitioning, which is the preferred partitioning method for non-universal table spaces.
Deprecated subsystem parameter: Non-default settings for PREVENT_NEW_IXCTRL_PART are deprecated. Db2 13 supports these settings, but their use is discouraged, and support is likely to be removed eventually. For best results, use the default value YES.
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| DSNZPxxx: | DSN6SPRM PREVENT_NEW_IXCTRL_PART |
- YES
- Specifies that new partitioned table spaces must use table-controlled partitioning. A CREATE INDEX statement must not attempt to create an index-controlled partitioned table.
- NO
- Specifies that new index-controlled partitioned tables can be created.
Learn more: For comprehensive
background, how-to information, and examples for various paths for converting your deprecated
classicpartitioned (non-UTS) table spaces to partition-by-range table spaces, see the white paper Conversion from index-controlled partitioning to Universal Table Space (UTS).