The SYSCS_UTIL.SYSCS_CHECK_TABLE() function checks the consistency
of a table. In
particular, the SYSCS_UTIL.SYSCS_CHECK_TABLE function verifies the
following conditions:
- Base tables are internally consistent
- Base tables and all associated indexes contain the same number of rows
- The values and row locations in each index match those of the base table
- All BTREE indexes are internally consistent
You run this function in an SQL statement, as follows:
VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE(
SchemaName, TableName)where SchemaName and TableName are
expressions that evaluate to a string data type. If you created a schema or
table name as a non-delimited identifier, you must present their names in
all upper case. For example:VALUES SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'CITIES')
The SYSCS_UTIL.SYSCS_CHECK_TABLE function returns a smallint.
If the table is consistent (or if you run SYSCS_UTIL.SYSCS_CHECK_TABLE on
a view), SYSCS_UTIL.SYSCS_CHECK_TABLE returns a non-zero value. Otherwise,
the function throws an exception on the first inconsistency that it finds.
For a consistent table, the following result is displayed:
1
-----
1
1 row selected