O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required