SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
5-80
Considerations for VERIFY
guardian-file-name
is a single Guardian physical file name to be verified. The Guardian file name
specification can contain a node, volume, subvolume, and a file name. The node
name is optional.
wildcard-guardian-file-name
allows wild card character “*” as part of the Guardian file name. For example,
\dmr15.$*.*.*
\dmr15.$data*.ZSDV1*.PART*
OSS-file-name
the name of an OSS file. When the -oo option is used, VERIFY writes the names
of orphaned Guardian files to this file, one orphaned file name per line.
[\node.]$volume.subvol.filename
is the Guardian qualified file name that describes the partition that is being queried.
In this four-part name, \node is the name of a node of a NonStop server, $volume
is the name of a disk volume, subvol is the name of a subvolume, and filename
is the name of an SQL/MX table or view.
If the name contains special characters such as “\” or “$”, you must precede these
characters with a backslash (\), or you can enclose the entire four-part name in
single quotes. For example:
\\node2.\$data3.sales.mytable or '\node2.$data3.sales.mytable'.
If you do not specify \node, the default is the Guardian system named in your
=_DEFAULTS define.
You can find the Guardian (physical) file name by using the SHOWLABEL
command. For example:
SHOWLABEL CAT.SCH.T1, DETAIL;
For more information, see SHOWLABEL Command on page 4-99.
Considerations for VERIFY
When the object option or file option is used, VERIFY checks for inconsistencies
between information stored in the metadata and information stored in labels, including:
•
ANSI name
•
ANSI namespace
•
Partition map, including:
°
Number of partitions
°
First key values
°
Physical locations
•
Version information