HPE NonStop SQL/MX Error – 20407 The original MODIFY REORG command is not active. For SUSPEND and CANCEL commands, the original MODIFY REORG command must be active.

In this blog post, let’s learn about the error message “20407 The original MODIFY REORG command is not active. For SUSPEND and CANCEL commands, the original MODIFY REORG command must be active.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20407 The original MODIFY REORG command is not active. For SUSPEND and CANCEL commands, the original MODIFY REORG command must be active.

Reason for the Error

You issued either SUSPEND or CANCEL command when the original REORG is no longer active.

Solution

Issue SUSPEND or CANCEL command only when the original REORG command is still active