-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