O'Reilly logo

Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition by Susan Visser, Bill Wong

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

Chapter 16. Recovery Concepts

When you have data in your database, you must guard against losing this data. DB2 is equipped with tools to help you back up and recover your data.

One advantage of a database management system over storing data in files, is the backup and recovery procedures that can be used to rebuild the database if it becomes damaged in some way. The rebuilding of the database is called recovery, and DB2 supports the following types of recovery:

  • Crash recovery—The automatic recovery of the database if a failure occurs before all the updates in a given transaction are completed and committed. For example, if a banking transaction involved withdrawing funds from one account and depositing them into another account, DB2 would either ...

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