The Validation utility
150
For example, the following validates the sample database, connecting as user
DBA with password SQL:
dbvalid -c "uid=DBA;pwd=SQL;dbf=c:\asa6\asademo.db"
Data check for each table (–fd) In addition to the default validation
checks, check that all of each LONG BINARY, LONG VARCHAR, TEXT,
or IMAGE data type can be read. This corresponds to the WITH DATA
CHECK option on the VALIDATE TABLE statement. Depending on the
contents of your database, this option may significantly extend the time
required to validate.
Full check for each table (–f) In addition to the default validation
checks, carry out both data checks (
-fd) and index checks (-fi). This
corresponds to the WITH FULL CHECK option on the VALIDATE TABLE
statement. Depending on the contents of your database, this option may
significantly extend the time required to validate.
Index check for each table (–fi) In addition to the default validation
checks, validate each index on the table. This corresponds to the WITH
INDEX CHECK option on the VALIDATE TABLE statement. Depending
on the contents of your database, this option may significantly extend the
time required to validate.
Validate specified indexes (–i) Instead of validating tables, validate
indexes. In this case, for
dbvalid
, each of the object-name values supplied
represents an index rather than a table, and has a name of the following form:
[ [
owner
.]
table-name
.]
index-name
Log output messages to file (–o) Write output messages to the named
file.
Operate quietly (–q) Do not display output messages. This option is
available only from the command-line utility.
Validate tables (–t) The list of object-name values represents a list of
tables. This is also the default behavior.
To Next Page
Loading...