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

Performing Recovery Operations
HP NonStop SQL/MX Installation and Management Guide—523723-004
12-30
Identifying Problem Data and Objects
This VERIFY feature compares information saved in the DP2 file label with similar
information stored in metadata and returns inconsistencies. This information is
compared for each Guardian file associated with the object:
°
Redefinition time
°
Extent sizes (primary extent size, secondary extent size, maxextents)
°
Audit flag
°
Corrupt flag
For dependent indexes and for each table that contains an index, VERIFY ensures
that the index map array exists and contains the correct number of indexes.
•
Checks that dependent, partitionable objects exist and are defined correctly.
For each partition of a table and any dependent indexes, VERIFY checks that:
°
The encoded key values are the same.
°
The physical locations are the same.
°
The partition map in the resource fork contains all partitions defined for the
table (except offline partitions).
°
The partition map stored in the index map array of a table is correct.
Security Considerations
•
VERIFY does not check privilege information.
•
You must be logged on using the super ID, be owner of the schema where the
object being verified resides, or have SELECT privilege on the object being
verified.
•
VERIFY obtains read-only locks on metadata while verifying an object. Other
operations that read metadata can run concurrently. Operations that change
metadata or labels such as DDL, partition management, PURGEDATA, and
UPDATE STATISTICS statements cannot run concurrently.
•
To verify some objects, NonStop SQL/MX might need to access remote systems.
In this case, the remote systems must be available, and you must have privileges
to view information on them.
•
If VERIFY tries to access objects on a remote system that were created on a
schema version later than the current system version, you receive a versioning
error.
Using INFO to Display Guardian File Information
Use the mxtool INFO command to request-specific SQL/MX information for a given
Guardian file name. NonStop SQL/MX automatically generates Guardian file names
that are randomly created. Use the INFO command to determine which Guardian file
names belong to which ANSI object, without writing complex queries against metadata.
With INFO you can obtain this information even if metadata is unavailable. In addition,