Performs a full (normal) validation of an UltraLite database.
Syntaxulvalid -c "connection-string" [ options ]
| Option | Description |
|---|---|
| @data | Use this to read in options from the specified environment variable or configuration file. If both exist with the same name, the environment variable is used. |
| -c "connection-string" | Required. Connect to the database as identified in connection-string. If you do not specify both a user ID and a password, the default UID of DBA and PWD of sql are assumed. |
| -e |
Express validation. Only perform table validation. This option provides a faster validation than normal validation. |
| -q | Set the utility to run in quiet mode. Suppress informational banners, version numbers, and status messages. Error messages are still displayed, however. |
| -v | Print verbose messages. |
| -? | Displays utility usage information and exits. |
RemarksValidating a database verifies the accuracy of the table metadata and ensures the file has not been corrupted.
The validation includes:
Database pages Validate all database pages, using checksums when enabled. Note that certain critical pages always have checksums and even pages without checksums undergo a basic validity check.
Tables Validate table(s) by checking that the table row count matches the count in each index.
Indexes Validate indexes by checking that entries refer to valid rows. ulvalid -e performs an express check, which includes only table validation.
See also ExampleAn example of an express validation of a database named sample.udb run in quiet mode.
ulvalid -c DBF=sample.udb -e -q |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |