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.
Acceptable values: | NO, YES |
Default: | NO |
DSNZPxxx: | DSN6SPRM PREVENT_NEW_IXCTRL_PART |
- NO
- Specifies that new index-controlled partitioned tables can be created.
NO is the default value.
- 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.