SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
V-2
Consideration—VERIFIEDWRITES
Consideration—VERIFIEDWRITES
On a verified write, the disk controller hardware makes a byte-by-byte comparison
between the newly written data and the corresponding data in the controller's memory.
Verified writes help ensure the accuracy of write operations, but they increase
response time and disk utilization.
VERIFY Command
VERIFY is an SQLCI utility command that reports whether SQL objects and programs
are consistently described in the file labels and the catalog.
VERIFY also lists invalid SQL programs described in specified catalogs and optionally
generates a command file to recompile the invalid programs stored on Guardian files.
(The command file does not include commands to recompile invalid programs stored
on OSS files.)
[ DEF[INITION] [OF] ]
is an optional phrase that does not change the meaning of the command. The
words DEFINITION and OF are reserved words.
qualified-fileset-list
is a qualified fileset list that specifies SQL objects and programs to verify, either
directly or indirectly (by specifying catalogs or subvolumes that include the objects
and programs). For information, see Qualified Fileset List on page Q-1.
If qualified-fileset-list includes a FROM CATALOGS clause, VERIFY
expands a list containing wild-card characters using the specified catalogs; if you
omit FROM CATALOGS, VERIFY expands the list using the Guardian disk
directory.
To list invalid programs only, use qualified-fileset-list with the WHERE
SQLPROGRAM qualifier.
If SMF is installed on your node, qualified-fileset-list cannot specify any
file, program, or object on a $*.ZYS*. subvolume.
SOURCE edit-file [ CLEAR ]
directs SQL to generate SQLCOMP commands to recompile any invalid SQL
programs on Guardian files included in qualified-fileset-list and to write
the SQLCOMP commands in an EDIT file named edit-file. If edit-file does
not exist, SQL creates it.
VERIFY [ DEF[INITION] [OF] ] qualified-fileset-list
[ [,] SOURCE edit-file [ CLEAR ] ][REPAIR];