The dbvalid utility is a validation utility that validates the indexes and keys on some or all of the SAP SQL Anywhere tables in the catalog store.
The Validation utility scans the entire table and looks up each record in every index and key defined on the table. By default, the Validation utility uses the express check option.
You can access the dbvalid utility at the system command-line level, which is useful for incorporating dbvalid into batch or command files.
This table lists the options available for the dbvalid utility.
With the dbvalid command-line utility, you can validate the indexes and keys on some or all of the tables in the catalog store. dbvalid scans the entire table and confirms that each row exists in the appropriate indexes. It is the same as running the SQL Anywhere VALIDATE TABLE statement on each catalog store table.
By default, the Validation utility uses the express check option. However, the express check option is not used if you specify -f, -fd, -fi, -fn, or -i.
If the catalog store table is inconsistent, dbvalid reports an error. If errors are reported, you can drop all of the indexes and keys on a table and re-create them. You must also re-create any foreign keys to the table.
Program exit code |
Description |
---|---|
0 |
Database validated successfully |
1 |
General failure in utility |
2 |
Error validating database |
7 |
Cannot find database to connect to (database name is wrong) |
8 |
Cannot connect to database (user ID/password is wrong) |
11 |
Cannot find server to connect to (server name is wrong) |
12 |
Incorrect encryption key for starting database |