In this blog post, let’s learn about the error message “20861 The corrupt bit has been reset for only local partitions of file-name. Please execute the command on the remote nodes to update respective remote partitions.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20861 The corrupt bit has been reset for only local partitions of file-name. Please execute the command on the remote nodes to update respective remote partitions.
Reason for the Error
This message is displayed whenever FIXUP is used with the “-rc” option on a table or index with partitions on a remote node.
Solution
Clear the corrupt bit on each remote node by issuing the FIXUP command with the ‘-rc” option