Reference Manual
   CHAPTER 4. Database Administration Utilities     

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) 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, for interactive use under Windows 95 or NT.

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

  Validating a database from Sybase Central

  To validate a running database:

1. Connect to the database.

2. Right-click the database, and click Validate in the popup menu.

  To validate an individual table:

1. Connect to the database.

2. Locate the table you wish to validate.

3. Right-click the table, and click Validate in the popup menu.

     For full information on validating a database from Sybase Central, see the Sybase Central online Help.

  The DBVALID command-line utility

Syntax 

dbvalid [switches] [table-name,...]

Windows 3.x
syntax 

dbvalidw [switches] [table-name,...]

Switch	Description
-c "keyword=value; ..."	Supply database connection parameters
-q	Quiet mode—do not print messages

Description 

With the command line Validation utility, you can validate the indexes and keys on some or all of the tables in the database. This utility scans the entire table, and looks up each record in every index and key defined on the table.

     For more information about the command-line switches, see Validation utility options.

  Validation utility options

Connection parameters (-c )     For a description of the connection parameters, see Connection parameters. If the connection parameters are not specified, connection paremeters from the SQLCONNECT environment variable are used, if set. The user ID must have DBA authority.

For example, the following validates the sample database, connecting as user DBA with password SQL:

dbvalid -c "uid=dba;pwd=sql;dbf=c:\asa6\asademo.db"

Operate quietly (-q )     Do not display messages on a window. This option is available only from the command-line utility.