HPE NonStop SQL/MX Error – 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.

Data 16 Views 1 Min Read

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

Tags: