HPE NonStop SQL/MX Error – 20254 Partition could not be reused because the partition’s key range contains data and the PURGEDATA option was not specified.

In this blog post, let’s learn about the error message “20254 Partition could not be reused because the partition’s key range contains data and the PURGEDATA option was not specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20254 Partition could not be reused because the partition’s key range contains data and the PURGEDATA option was not specified.

Reason for the Error

The specified partition contains data, but you did not specify the PURGEDATA option in the REUSE request.

Solution

None