In this blog post, let’s learn about the error message “20404 The REORG operation on object-type object-name has already been suspended.object-typeis the type of the affected SQL/MX table or index.object-nameis the ansi-name of the affected SQL/MX table or index.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20404 The REORG operation on object-type object-name has already been suspended.object-typeis the type of the affected SQL/MX table or index.object-nameis the ansi-name of the affected SQL/MX table or index.
Reason for the Error
You issued MODIFY REORG with the SUSPEND action on an already suspended REORG operation.
Solution
As operation is already suspended, no recovery is required