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-79

VERIFY Operation

Considerations for VERIFY

Examples of VERIFY

VERIFY is an OSS command-line utility run from mxtool that reports whether

SQL/MX objects and programs are consistently described in file labels, resource forks,

and metadata. Starting with SQL/MX Release 3.2, the VERIFY operation can produce

a list of orphaned Guardian files. The orphaned Guardian files are existing Guardian

files for which metadata information is not available in the SQLMX database.

object-option

specifies that VERIFY should be performed against all partitions and dependent

indexes of a table.

catalog.schema.object

is the fully qualified ANSI name of a table. If any of the three parts of the name is

an SQL/MX reserved word, you must delimit it by enclosing it in double quotes.

Such delimited parts are case-sensitive. For example: cat.sch."join".

VERIFY displays inconsistencies to the standard output file.

file-option

specifies that VERIFY should be performed against a file. Only a table object can

be specified.

orphan-file-option

specifies that VERIFY must report the name(s) of an orphaned Guardian file or set

of files.

mxtool VERIFY { object-option | file-option | orphan-file-

option}

object-option is: ANSI name of the object

file option is: PART guardian-file-name

guardian-file-name is: [\node.]$volume.subvol.filename

orphan-file-option is: -oo wildcard-guardian-file-name

output

wildcard-guardian-file-name is:

Guardian file name, which includes the wild card character,*.

output is: -f=OSS-file-name