Creating tables that use index-controlled partitioning

Tables that use index-controlled partitioning require a partitioning index. Because the index is created separately from the associated table, you cannot insert data into the table until the partitioning index is created.

About this task

Recommendation: Start of change

Create partitioned tables with table-controlled partitioning instead of index-controlled partitioning. End of change

Restriction: Start of change

If the PREVENT_NEW_IXCTRL_PART subsystem parameter is set to YES, you cannot create tables that use index-controlled partitioning. End of change

Procedure

To create tables that use index-controlled partitioning:

Define a partitioning index on a table in a partitioned table space. Specify the partitioning key and the limit key values in the PARTITION clause of the CREATE INDEX statement.