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

Performing Recovery Operations
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
12-27
Identifying Problem Data and Objects
VERIFY
Use the mxtool VERIFY utility to check consistency within the database between
metadata, resource forks, and file labels. For information about using VERIFY, see
Using VERIFY to Check Data Consistency
on page 12-30.
Correcting Problems Manually
You can correct some problems in metadata directly by manually executing inserts,
updates, selects, and deletes. Any SQL/MX user can read metadata, but only DDL and
utility operations can update it. Therefore, NonStop SQL/MX allows the super ID to fix
incorrect metadata through standard INSERT, UPDATE, and DELETE statements
using a licensed MXCI process. However, use this method only as a last resort to
correct a problem.
Identifying Problem Data and Objects
NonStop SQL/MX keeps information about object structures in metadata, resource
forks, and DP2 labels. DP2 labels consist of file structure information and security
settings. Resource forks contain specific SQL/MX information that includes, among
other things, the ANSI name, partition maps, row and key information, and system
metadata location. Metadata contains a description of all the objects in a database.
During regular processing, information between metadata, DP2 labels, and resource
forks can become inconsistent. Use the VERIFY command to detect these problems
and report them to users. Use the INFO command with VERIFY to display various
areas of the database as described next, independent of whether a problem is
detected.
VERIFY checks for:

Inconsistencies between an SQL/MX table and its structural representation in the
resource fork

Inconsistencies between an SQL/MX table and its structural representation in
corresponding DP2 labels

The existence of dependent partitionable objects and their correct definitions
INFO displays SQL/MX related information given a Guardian qualified file-set list
Types of Data Problems
Label Data
Table 12-1 describes the information that is stored in the various labels associated with
SQL/MX format objects.