Performs a full ("normal") validation of an UltraLite database.
ulvalid -c "connection-string" [ options ]
Option | Description |
---|---|
-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. |
Validating a database verifies the accuracy of the table meta-data 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. See UltraLite checksum_level creation parameter.
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.
An 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 © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |