Validates all tables in the Catalog Store.
sa_validate [ tbl_name, ] [ owner_name, ] [ check_type ]
DBA authority required.
This procedure validates each SQL Anywhere table or index in the Catalog Store.
For more information, see “The Validation utility (dbvalid)” in Chapter 3, “Database Administration Utilities” of the Sybase IQ Utility Guide.
Table 9-28 lists the meaning of the sa_validate parameters.
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 arguments 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 may be reported indicating some form of database corruption even though no corruption actually exists.
The following statement validates all of the Catalog Store tables owned by the DBA with an index check:
CALL sa_validate (owner_name='DBA', check_type = 'index')
