SQL/MP Installation and Management Guide

HP NonStop SQL/MP Installation and Management Guide—523353-004
6-1
6
Querying SQL/MP Catalogs
SQL/MP catalogs contain information you can use to manage the database. Obtaining
information from the catalogs with SQL queries can help you determine the current
status of the database. You can also use the FILEINFO and VERIFY utilities to show
the status of objects and the DISPLAY USE OF utility to show usage relationships.
Determining Object and Program
Dependencies
The USAGES catalog table stores information about dependencies between objects. A
dependent object and the object on which it depends can be registered in different
catalogs; therefore, the USAGES tables in both catalogs have an entry about the
dependency. This table lists initial and dependent objects:
The next example illustrates corresponding dependency entries for a table and a
dependent program whose definitions are stored in different catalogs on different
nodes.
Initial Object Dependent Objects
Table Index
Protection view
Shorthand view
SQL object program
Protection view Shorthand view
SQL object program
Shorthand view Shorthand view
SQL object program
Index SQL object program
Collation Table
Index
Protection view
Shorthand view
SQL object program
Note. If you specify the NOREGISTER option for a program, as described under Moving
Programs on page 10-39, SQL/MP does not register the program in the catalog and it will not
appear as a dependent object. In addition, the program can be installed at a different location
(subvolume or node) without recompilation or registration.