Database Maintenance and Tuning
Checking Database Consistency
In perfectly normal environments and situations, you can be confident that the tables within an Apache Derby database are consistent. However, we live in a world in which events such as power surges or power loss can occur, or ruthless system administrators can prematurely terminate an Apache Derby process. Events that cause an unexpected interruption of the Apache Derby processes can, unfortunately, cause one or more tables in a database to be placed in an inconsistent state. After such an event, you should check the state of the tables in your database with the SYSCS_UTIL.SYSCS_CHECK_TABLE function. If you discover that one or more of your tables is in an inconsistent state, you ...
Get Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
