13.1. Database Recovery Concepts

Database recovery is how DB2 makes your database consistent in the event of a failure. A database is “consistent” when all committed transactions have been applied to the database and any uncommitted transactions that might have been performed have been rolled back.

13.1.1. Recovery Scenarios

To minimize the loss of your data, you need to have a recovery strategy, ensure that it works, and constantly practice it. The following are some recovery scenarios you should consider.

  • System outage: A power failure, hardware failure, or software failure can cause your database to be in an inconsistent state.

  • Transaction failure: Users may inadvertently corrupt your database by modifying it with incorrect data or delete ...

Get Understanding DB2®: Learning Visually with Examples 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.