SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-15
Examples of FIXUP Operation
•
Suppose a disk or node failure occurs and you must recover table FIXUPtable.
Following instructions in the SQL/MX Installation and Management Guide, you use
saved DDL information to recreate the table and recover the privileges in the
metadata, then execute the TMF RECOVER FILES command to recover the label,
data, and resource forks.
The metadata will now have a new object UID and the label information will have
the old object UID. When you perform a VERIFY on this file, because the UID
value in the metadata tables does not match the UID value in the resource fork.,
you receive this message:
20799 The { catalog | schema | object } UID in the resource
fork (value) does not match the UID (value) in the metadata
for Guardian file (filename).
Run FIXUP to make the UID value in the resource fork match the UID value in the
metadata:
mxtool FIXUP TABLE mycat.mysch.FIXUPtable -ru -d