HPE NonStop SQL/MX Error – 20270 Redefinition timestamp has been reset for only local partitions of name object. Please execute the command on the remote nodes to update respective remote partitions.

In this blog post, let’s learn about the error message “20270 Redefinition timestamp has been reset for only local partitions of name object. 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

20270 Redefinition timestamp has been reset for only local partitions of name object. Please execute the command on the remote nodes to update respective remote partitions.

Reason for the Error

This warning message indicates that not all partitions associated with the specified object have had their redefinition timestamps updated.

Solution

After completing this request, the same request must be issued on all systems that contain a partition of the object