sa_validate system procedure

Function

Validates all tables in the Catalog Store.

Syntax

sa_validate [ tbl_name, ] [ owner_name, ] [ check_type ]

Permissions

DBA authority required.

Description

This procedure validates each SQL Anywhere table or index in the Catalog Store.

For more information, see “Validation utility (dbvalid)” in Chapter 3, “Database Administration Utilities” in the Sybase IQ Utility Guide.

Table 10-56 lists the meaning of the sa_validate parameters.

Table 10-56: sa_validate options

Option name

Values

tbl_name

Validate only the specified table. When NULL (the default), validate all tables.

owner_name

Validate only the tables owned by the specified user. When NULL (the default), validate tables for all users.

check_type

When NULL (the default), each table is checked without additional checks. The check_type value can be one of the following: data, express, full, index, or checksum.

Values for the tbl_name, owner_name, and check_type parameters are strings and must be enclosed in quotes.

The procedure returns a single column, named Messages. If all tables are valid, the column contains:

No errors detected

WARNING! Validate a table or the entire Catalog Store while no connections are making changes to the database; otherwise, spurious errors might be reported, indicating some form of database corruption even though no corruption actually exists.

Example

The following statement validates all of the Catalog Store tables with an index check owned by the DBA:

CALL sa_validate (owner_name='DBA', check_type = 'index')