In this blog post, let’s learn about the error message “20402 No REORG operation exists on 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
20402 No REORG operation exists on 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 MODIFY REORG with the STATUS, SUSPEND, ACTIVATE, or CANCEL action on an object when a REORG on the specified object is not in progress.
Solution
Specify a correct TABLE or INDEX name on which a REORG command is issued but it has not completed yet
