Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite utilities

UltraLite Validate Database utility (ulvalid)

Performs a full (normal) validation of an UltraLite database.

ulvalid -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.




Express validation. Only perform table validation. This option provides a faster validation than normal validation.




Set the utility to run in quiet mode. Suppress informational banners, version numbers, and status messages. Error messages are still displayed, however.




Print verbose messages.
--log=filename Log operations to the specified file.




Displays utility usage information and exits.

Validating 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. 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.


An example of an express validation of a database named sample.udb run in quiet mode.

ulvalid -c DBF=sample.udb -e -q