SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—523725-004
5-13
FIXUP Operation
o-opts
are options available for an SQL object:
•
Turn off the corrupt attribute
•
Reset the redefinition timestamp
{ -rc [-d] }
turns off the corrupt attribute on the label and in the PARTITIONS metadata table.
FIXUP attempts to reset all local partitions associated with the object. If the object
has partitions on remote nodes, FIXUP displays a warning and continues.
If an update to the label or metadata fails, the operation fails. If one of the partitions
already has the corrupt attribute turned off, FIXUP continues to reset partitions that
need to be reset.
If you specify the -d option, FIXUP resets the corrupt attribute of all dependencies
associated with the object. Table dependencies include indexes and trigger
temporary tables. Indexes have no dependencies, so the -d option is ignored.
You must be the super ID to execute this request. Both remote and local partitions
can have their corrupt attribute reset.
If the metadata and label attributes do not match, FIXUP turns both values off.
{ -rt [-d] }
sets the redefinition timestamp of one or all local partitions of an object to the value
saved in the OBJECTS metadata table. If FIXUP cannot extract the redefinition
time from the metadata, it returns an error.
FIXUP updates all partitions that make up the object, on the local node. If the
object has partitions on remote nodes, FIXUP displays a warning and continues.
If the partition has the same timestamp as the metadata, FIXUP continues to
update timestamps for partitions that need to be updated. If an update to the label
fails, the operation fails.
If you request the -d option, FIXUP updates timestamps for all dependencies
associated with the object. Table dependencies include indexes and trigger
temporary tables. Each dependent object has its own redefinition timestamp, so
each object is set to its own individual time.
You must be the super ID to execute this request.
If the metadata and label timestamps do not match, no warning is issued, but the
label value is set to the metadata value.
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.