-636   RANGES SPECIFIED FOR PARTITION part-num ARE NOT VALID

Explanation

The ranges specified for partition part-num are not valid for one of the following reasons:
  • The partitioning key values specified in the limit key value specifications were not in either ascending or descending order.
  • Start of changeA partitioning key value that was specified in the limit key value specifications already exists. Duplicate limit keys must not be specified. End of change
  • All of the columns in the partitioning key are ascending, and a constant or MINVALUE was specified following MAXVALUE in the limit key value specification for the partition. Once MAXVALUE is specified, all subsequent columns must be MAXVALUE.
  • All of the columns in the partitioning key are descending, and a constant or MAXVALUE was specified following MINVALUE in the limit key value specification for the partition. Once MINVALUE is specified, all subsequent columns must be MINVALUE.

System action

The statement cannot be processed.

User response

Correct the range partitioning specifications in the statement for the identified partition.

SQLSTATE

56016