The Validation utility
148
The Validation utility
With the Validation utility, you can validate the indexes and keys on some or
all of the tables in the database. The Validation utility scans the entire table,
and looks up each record in every index and key defined on the table.
This utility can be used in combination with regular backups (see "Backup
and Data Recovery" on page 645 of the book ASA User’s Guide) to give you
confidence in the integrity of the data in your database.
You can access the Validation utility in the following ways:
♦ From Sybase Central
♦ From the system command line, using the
dbvalid
command-line utility.
This is useful for incorporating into batch or command files.
$ For more information on validating tables, see "VALIDATE TABLE
statement" on page 644.
Validating a database from Sybase Central
You can validate a database from Sybase Central, and validate individual
tables.
v To validate a database:
1 Open the Utilities folder.
2 Double-click Validate Database.
3 Follow the instructions in the wizard.
v To validate a running database:
1 Connect to the database.
2 Right-click the database and choose Validate from the popup menu.
v To validate an individual table:
1 Connect to the database.
2 Locate the table you wish to validate.
3 Right-click the table and choose Validate from the popup menu.
To Next Page
Loading...