Start of change

-662   A PARTITIONED INDEX CANNOT BE CREATED ON A TABLE SPACE, OR A TABLE SPACE CANNOT BE INDEX-CONTROLLED. TABLE SPACE tspace-name, REASON reason-code

Explanation

The CREATE INDEX statement could not be processed. The value in reason-code identifies the problem.

01
The CREATE INDEX statement contains the PARTITION BY clause for index-controlled partitioning, but the table on which the index is created has one of the following characteristics:
  • The table is not in a partitioned table space.
  • The table is in a partition-by-growth or a range-partitioned universal table space.
02
The CREATE INDEX statement contains the PARTITIONED option, but the table on which the index is created has one of the following characteristics:
  • The table is not in a partitioned table space.
  • The table is in a partition-by-growth table space.

System action

The statement cannot be processed. The specified index was not created.

Programmer response

Verify that the proper object table was specified in the statement. Review the proper usage of the PARTITION BY clause or the PARTITIONED option in CREATE INDEX statements

SQLSTATE

53037

End of change