SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
8-66
Displaying Object Integrity and Consistency
name>.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access;
GRANTOR_ID GRANTOR_T GRANTEE_ID GRANTEE_T PRVTYPE GRANTABLE
---------- --------- ----------- --------- ------- ---------
-2 System 65535 Unknown Refer Y
-2 System 65535 Unknown Update Y
Displaying Object Integrity and Consistency
The mxtool VERIFY command detects and reports inconsistencies between the
information contained in the metadata, the resource forks, and the file labels. It does
not verify data integrity. This command is often used together with the
mxtool INFO
command, which displays various aspects of a database.
An object has definitional integrity if it is consistently described in the metadata, the
resource forks, and the file labels, and if the descriptions of all related objects are valid.
A database can become inconsistent through database changes that are not applied
consistently throughout related objects. SQL can prevent many of the operations that
cause inconsistency, but it does not always detect all operational errors. For example,
when you drop a table, SQL attempts to drop all dependencies. However, a user might
restore objects that might not be consistent with the related objects. System
operational problems or system failures can also cause inconsistencies in the data
dictionary.
For detailed information and examples of the
mxtool VERIFY command, see the
SQL/MX Reference Manual.
Displaying Version Numbers
Topics in this subsection:

Displaying the NonStop SQL/MX Release Identifier on page 8-67

Displaying the Schema Version on page 8-67

Displaying the System Schema Version on page 8-67

Displaying the Object Schema Version (OSV) on page 8-67

Displaying the Object Feature Version (OFV) on page 8-67
Note. HP recommends that you run the mxtool VERIFY command once a week on
frequently used objects for early problem detection and resolution.