DB2 SQL-Error: -660
SQLState: 53035
Short Description: INDEX CANNOT BE CREATED OR ALTERED ON PARTITIONED TABLE SPACE BECAUSE KEY LIMITS ARE NOT SPECIFIED
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 executed. 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. Refer to Chapter 5 of DB2 SQL Reference for information about the requirements that must be satisfied by the definitions for the cluster indexes for partitioned tables.