logo  
Google
 

DB2 SQL-Error: -636

SQLState: 56016

Short Description: THE PARTITIONING KEYS FOR PARTITION ARE NOT SPECIFIED IN ASCENDING OR DESCENDING ORDER

In the CREATE INDEX or ALTER INDEX statement for the CLUSTER index for a partitioned table (that is, a table residing in a partitioned table space), the partitioning key values specified in the limit key value specifications were not in either ascending or descending order. System action: The statement cannot be executed. The specified cluster index was not created. Programmer response: Correct the limit key value specifications in the CREATE INDEX or ALTER INDEX statement for the identified partitionso that the limit key values for successive partitions are in strictly ascending or descending order.

 <-  BACK TO INDEX