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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-83
Considerations for VERIFY
If you do not specify \node, the default is the Guardian system named in your
=_DEFAULTS define.
You can find the Guardian (physical) file name by using the SHOWLABEL
command. For example:
SHOWLABEL CAT.SCH.T1, DETAIL;
For details on this command, see SHOWLABEL Command on page 4-78.
Considerations for VERIFY
You must have SELECT privilege for all columns of the table you are verifying.
VERIFY checks for inconsistencies between information stored in the metadata and
information stored in labels, including:
•
ANSI name
•
ANSI namespace
•
Partition map, including:
°
Number of partitions
°
First key values
°
Physical locations
•
Version information
•
Number of indexes
•
Partition name
•
For dependent indexes, similar checks are made for inconsistencies, including:
°
ANSI name
°
ANSI namespace
°
Partition map
°
Version information
•
Constraint information.
Constraint information stored in the label is used during similarity checking to see if
the current plan can be executed or needs to be recompiled. The number of
constraints defined must be the same. In addition, the constraint text and disabled
attribute must match. Only droppable check constraint information is verified.
•
Redefinition time
•
Extent sizes (primary extent size, secondary extent size, maximum number of
extents)
•
Audit flag
•
Corrupt flag
If a table has offline partitions or unpopulated indexes defined in metadata, they are
noted in the output. If a table has both offline partitions and unpopulated indexes
defined in metadata, they will be ignored.