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