SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—640325-001
12-30
Identifying Problem Data and Objects
Using SHOWLABEL to Retrieve Run-Time Metadata
You can also use the SHOWLABEL command to retrieve run-time metadata from both
the labels and the resource fork of a Guardian file. For command syntax and example
outputs, see the SQL/MX Reference Manual.
SHOWLABEL displays this information:
•
The ANSI file name
•
The ANSI namespace, including table namespace (which includes views and
SPJs), index namespace, and trigger namespace
•
The object schema version
Using VERIFY to Check Data Consistency
Infrequently, information between labels, resource forks, and metadata becomes
inconsistent. The VERIFY operation detects and reports these inconsistencies. For
command syntax and example outputs, see the SQL/MX Reference Manual.
VERIFY performs these actions:
•
Checks for inconsistencies between an SQL/MX table and its structural
representation in the resource fork.
This feature compares information saved in the resource fork with similar
information stored in metadata and returns inconsistencies. This information is
compared:
Constraint
information
Contains entries for droppable check constraints. This information is
needed for similarity-checking to determine whether plans need to be
recompiled because of a new or deleted check constraint.
Trigger information Indicates whether or not a trigger is enabled.
Key range
information
The low-key and high-key information for the partition of the SQL/MX
format object used by DP2 to do key-range checking, as is the case
for SQL/MP.
Logical partition
name information
Contains the logical name information that uniquely identifies the
partition of the SQL/MX format object.
Parent object
ANSI name
Contains the ANSI name associated with the parent SQL/MX format
object. This information is useful for ANSI indexes.
ANSI unique
identifiers
The unique IDs associated with the SQL/MX catalog and schema in
which the SQL/MX format object is registered, as well as the unique
ID of the SQL/MX format object itself.
Table 12-2. Run-time metadata Stored in the Resource Fork
Run-time
metadata Contents