In this blog post, let’s learn about the error message “20857 FIXUP did not change the redefinition timestamp for file file-name. It is already set to the correct value of time.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20857 FIXUP did not change the redefinition timestamp for file file-name. It is already set to the correct value of time.
Reason for the Error
The “-rt” option was used with the FIXUP utility to set the correct redefinition timestamp for an SQL/MX object, but the time was already the same time recorded in the file label for the object.
Solution
No recovery is necessary