Checking Database Consistency

Derby is a robust product containing many safeguards to ensure that the database remains consistent.

If, however, you have experienced hardware or operating system failure and you want to verify that the database is still consistent, Derby provides a way to do this. Check consistency only if there are indications that such a check is needed, because a consistency check can take a long time on a large database.

• The SYSCS_CHECK_TABLE function
• Sample Error Messages
• Sample Queries