Class ConsistencyChecker
This class can only be used within an SQL-J statement, a Java procedure or a server side Java method.
This class can be accessed using the class alias CONSISTENCYCHECKER
in SQL-J statements.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic boolean
checkTable
(String schemaName, String tableName) Check the named table, ensuring that all of its indexes are consistent with the base table.
-
Constructor Details
-
ConsistencyChecker
private ConsistencyChecker()no requirement for a constructor
-
-
Method Details
-
checkTable
Check the named table, ensuring that all of its indexes are consistent with the base table. Use this method only within an SQL-J statement; do not call it directly.When tables are consistent, the method returns true. Otherwise, the method throws an exception.
To check the consistency of a single table:
VALUES ConsistencyChecker::checkTable(SchemaName, TableName)
For example, to check the consistency of the table APP.Flights:
VALUES ConsistencyChecker::checkTable('APP', 'FLIGHTS')
To check the consistency of all of the tables in the 'APP' schema, stopping at the first failure:
SELECT tablename, ConsistencyChecker::checkTable(
'APP', tablename)
FROM sys.sysschemas s, sys.systables t WHERE s.schemaname = 'APP' AND s.schemaid = t.schemaidTo check the consistency of an entire database, stopping at the first failure:
SELECT schemaname, tablename,
ConsistencyChecker::checkTable(schemaname, tablename)
FROM sys.sysschemas s, sys.systables t
WHERE s.schemaid = t.schemaid- Parameters:
schemaName
- The schema name of the table.tableName
- The name of the table- Returns:
- true, if the table is consistent, exception thrown if inconsistent
- Throws:
SQLException
- Thrown if some inconsistency is found, or if some unexpected exception is thrown..
-