In this post, you’ll learn about the error message -660 index index name cannot be created on partitioned tablespace tspace name because key limits are not specified in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-660 index index name cannot be created on partitioned tablespace tspace name because key limits are not specified
Reason for the Error
The CREATE INDEX statement attempted to create a cluster index for a partitioned table (that is, a table residing in a partitioned table space) without specifying limit key values for the partitions of the table space.
Solution
Verify that the correct table was specified in the CREATE 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.
