Sybase Adaptive Server Anywhere - Page 167

Chapter 4 Database Administration Utilities
149
Tip
For validating database, you can also access this wizard by clicking
Tools➤Adaptive Server Anywhere➤Validate Database.
The dbvalid command-line utility
dbvalid [ switches ] [ object-name,... ]
Switch Description
object-name The name of a table or (if -i is used) an index to
validate
–c "keyword=value; ..." Supply database connection parameters
–o filename Log output messages to a file
–f
Validate tables with full check
–fd
Validate tables with data check
–fi
Validate tables with index check
–i
Each object-name is an index
–q
Quiet mode—do not print messages
–t
Each object-name is a table
With the command line Validation utility, you can validate the indexes and
keys on some or all of the tables in the database. This utility scans the entire
table, and confirms that each row in the table exists in the appropriate
indexes. It is equivalent to running the VALIDATE TABLE statement on
each table.
$ For information on specific checks made during validation, see
"VALIDATE TABLE statement" on page 644.
$ For more information about the command-line switches, see
"Validation utility options" on page 149.
Validation utility options
Connection parameters (–c) For a description of the connection
parameters, see "Connection parameters" on page 64 of the book ASA User’s
Guide. The user ID must have DBA authority or REMOTE DBA authority.
Syntax
Description