-660   INDEX index-name CANNOT BE CREATED OR ALTERED ON PARTITIONED TABLE SPACE tspace-name BECAUSE KEY LIMITS ARE NOT SPECIFIED

Explanation

The CREATE INDEX or ALTER INDEX statement did not specify limit key values for the partitions of the table space. To create a clustering index for a table in a partitioned table space, or to modify those values using ALTER INDEX, you must include those values.

System action

The statement cannot be processed. The specified cluster index was not created or altered.

Programmer response

Verify that the correct table was specified in the CREATE INDEX or ALTER INDEX statement. If so, the definition for the partitioned table space must be examined so that a proper definition for the cluster index for the table may be constructed.

SQLSTATE

53035