SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
5-8
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.
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 | SEQUENCE }
object-name is catalog.schema.object
o-opts is: { -rc | -rt | -ru } [-d]