SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-3
mxtool INFO Command
For detailed information and examples of this command, see the SQL/MX Reference
Manual.
mxtool INFO Command
Use the mxtool INFO command to display information about a database, including
SQL/MX-related information for a given Guardian file set list.
Because access to metadata is open to all users, anyone can run the mxtool INFO
command.
For detailed information and examples of this command, see the SQL/MX Reference
Manual.
SHOWLABEL Command
Use the MXCI SHOWLABEL command to display file-label information about SQL/MX
objects (tables, trigger temporary tables, views, and indexes), including the version and
physical location. The SHOWLABEL command also displays information about utility
operations in progress that affect the current state of a specified object. SHOWLABEL
does not support SQL/MP objects or SQL/MP aliases.
The SHOWLABEL command is similar to the SQL/MP FILEINFO, DETAIL command.
For detailed information and examples of this command, see the SQL/MX Reference
Manual.
mxtool VERIFY command
Use the mxtool VERIFY command to detect and display inconsistencies in the
database, including:
•
Inconsistencies between an SQL/MX table, view, or stored procedure in Java
(SPJ) and its structural representation in the resource fork
•
Inconsistencies between an SQL/MX table, view, or SPJ and its structural
representation in the corresponding file labels
•
Inconsistencies between an SQL/MX table and its dependent indexes
•
Incorrectly defined dependent partitionable objects
The mxtool VERIFY command is similar to the SQL/MP VERIFY command.
For detailed information and examples of this command, see the SQL/MX Reference
Manual.