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
