Collection Contents Index The Upgrade utility The Write File utility pdf/chap4.pdf

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:

For Info     For more information on validating tables, see VALIDATE TABLE statement.

Top of page  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 Info     For full information on validating a database from Sybase Central, see the Sybase Central online Help.

Top of page  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 Info     For more information about the command-line switches, see Validation utility options.

Top of page  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.

Top of page  

Collection Contents Index The Upgrade utility The Write File utility pdf/chap4.pdf