In this blog post, let’s learn about the error message “20405 No suspended REORG operation exists for object-type object-name.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
20405 No suspended REORG operation exists for object-type object-name.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 ACTIVATE action on an object on which no suspended REORG operation exists.
Solution
As operation is already active, no recovery is required