Start of changePREVENT_NEW_IXCTRL_PART in macro DSN6SPRMEnd of change

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 12 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: Start of changeYES, NOEnd of change
Default: Start of changeYESEnd of change
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 classic partitioned (non-UTS) table spaces to partition-by-range table spaces, see the white paper Conversion from index-controlled partitioning to Universal Table Space (UTS).