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-26
Identifying Problem Data and Objects
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.
Table 12-1. Label Data Associated With SQL/MX Objects (page1of2)
Label Field Contents
Data fork name This name matches the external file label name and is of the form
ZSDXXXXXX.YYYYYY00.
Resource fork
name
This name is similar to the data fork name, except it ends in “01” (for
example, ZSDXXXXXX.YYYYYY01).
File code The file code that is used by NonStop SQL/MX. Unlike with NonStop
SQL/MP, you cannot choose your own file codes.
File type Only key-sequenced (file type 3) files are supported in NonStop
SQL/MX. Relative and entry-sequenced files are not.
File format Indicates whether the table is format 1 or format 2. The file format is
always format 2 for SQL/MX format objects.
Owner The owner of the file.