-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.
- A partitioning key value that was specified in the limit key value specifications already exists. Duplicate limit keys must not be specified.
- 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