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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-11
FIXUP Operation
FIXUP Operation
Considerations for FIXUP Operation
Examples of FIXUP Operation
FIXUP is an OSS command-line utility run from mxtool that repairs problems in the
SQL/MX database that cannot be repaired by normal operations.
guardian-file
specifies the Guardian file to be changed. It must be fully qualified with the volume
and subvolume name. If you specify \node, it must be the local node.
Because the name contains special characters such as “\” or “$”, you must
precede these characters with a backslash (\), or you can enclose the entire
four-part name in single quotes. For example:
\\node2.\$data3.sales.mytable or '\node2.$data3.sales.mytable'.
g-opts
are options available for a Guardian file:
•
Toggle the AUDIT attribute
•
Turn off the broken attribute
•
Turn off the corrupt attribute
•
Reset the redefinition timestamp
•
Fix inconsistent label and metadata object UIDs
mxtool utility-operation
utility-operation is:
FIXUP {guardian-option | object-option}
guardian-option is
LABEL guardian-file g-opts
guardian-file is [\node.]$volume.subvolume.filename
g-opts is: { -a= { on|off } | -rb | -rc | -rt | -ru }
object-option is
object-type object-name o-opts
object-type is { TABLE | INDEX }
object-name is catalog.schema.object
o-opts is: { -rc | -rt | -ru } [-d]