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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-12
FIXUP Operation
{ -a= { on | off }
toggles the audit attribute on the label. If the audit attribute is ON and you issue a
request to turn it on, FIXUP returns a warning that the audit attribute is already on.
If the audit attribute is OFF and you issue a request to turn it off, FIXUP returns a
warning.
You must be the super ID to perform this operation.
If you turn off auditing for the table, this invalidates online dumps. After the FIXUP
operation completes, you must perform a new TMF online dump for all partitions of
the table.
-rb
turns off the broken attribute on the label. If the broken attribute is already reset
and you issue a request to reset it, FIXUP returns a warning.
-rc
turns off the corrupt attribute in the label and in the PARTITIONS metadata table
for the specific partition. If the partition already has the corrupt attribute turned off
and you issue a request to turn it off, FIXUP returns a warning.
-rt
sets the redefinition timestamp in label to the value in the OBJECTS table. If the
partition already has the correct redefinition time and you issue a request to reset
it, FIXUP returns a warning.
You must be the owner of the object or super ID to execute this request.
-ru
sets the UID value in the resource fork to match the UID value in metadata.
NonStop SQL/MX replaces the catalog, schema, and object UIDs in the resource
fork with the values found in metadata.
object-type
is an SQL table or index which has an associated Guardian file.
Caution. The -rb operation to reset the broken attribute on the label is potentially a risky
operation. If the file is really broken and you reset the attribute, the consistency of the database
will be in question. In addition, the next time DP2 attempts to access the broken file, it resets
this attribute.
Caution. The -rc operation to turn off the corrupt attribute on the label is potentially a risky
operation. If the file is really corrupted and you reset the attribute, the consistency of the
database will be in question.