You can validate a database using the command line.
You must have the VALIDATE ANY OBJECT system privilege. It is best to validate when there is no other activity on the database.
Validating a table or an entire database should be performed while no connections are making changes to the database; otherwise, errors may be reported indicating some form of database corruption even though no corruption actually exists.
Context and remarks
If you are checking the validity of a backup copy, run the database in read-only mode so that it is not modified in any way. You can only do this if there were no transactions in progress during the backup.
Run the dbvalid utility:
dbvalid -c "connection-string"
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|