HPE NonStop SQL/MX Error – 20401 The value for the option option must be a number between low and high.optionis an actual option, one of: RATE, PRIORITY, SLACK, DSLACK, ISLACK, or CONCURRENCY.low and high are the boundaries for the range of valid values for option.

In this blog post, let’s learn about the error message “20401 The value for the option option must be a number between low and high.optionis an actual option, one of: RATE, PRIORITY, SLACK, DSLACK, ISLACK, or CONCURRENCY.low and high are the boundaries for the range of valid values for option.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20401 The value for the option option must be a number between low and high.optionis an actual option, one of: RATE, PRIORITY, SLACK, DSLACK, ISLACK, or CONCURRENCY.low and high are the boundaries for the range of valid values for option.

Reason for the Error

You specified an invalid option value.

Solution

For the RATE option: Specify a percentage between 1 and 100.For the SLACK, DSLACK, or ISLACK options: Specify a percentage between 1 and 99.For the PRIORITY option: Specify an NSK priority between 1 and 199.For the CONCURRENCY option: Specify a number between 1 and the actual number of partitions for the affected table or index