Verifying Databases
The Verify option performs database cleanup and maintenance activities such as the following:
• Check whether the server can connect to the database.
• Delete all disk files in the database directory that are no longer required.
• Search for and delete all temporary tables from the database.
• Search for and delete all expired tables from the database.
• Remove all references to deleted tables from the DBMS system catalogs.
• Check tables and report any inconsistencies found, making recommendations to repair those inconsistencies. Secondary indexes are checked but cannot be repaired. Referential integrity is verified between the internal pointers for long data types stored in base table records and the extension table records they point to; any inconsistencies are reported.
• Check tables using a stricter patch algorithm, which guarantees data integrity.
• Check the DBMS catalogs and report any inconsistencies found, making recommendations to repair those inconsistencies.
• Permit entry into an inconsistent database and force it to act as if it were in a consistent state.
• Ensure that a distributed database correctly reflects the release level of all remote databases that contain objects registered to the distributed database.
A good use for the Verify command is to check the integrity of a database before
backing it up (see
Back Up a Database).
For more information about verifying databases, see
Verify a Database. Also see the VERIFYDB command in the Ingres
Command Reference Guide.