O'Reilly logo

DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition by Paul C. Zikopoulos, George Baklarz

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 13. Database Recovery

• LOG FILES

• LOGGING

• BACKUP

• RESTORE

• ROLLFORWARD RECOVERY

• HIGH AVAILABILITY SCENARIOS

One of the fundamental functions of any database management system is the ability to recover from events that would lead to the integrity of the database being compromised. DB2 is no different in this regard and has a number of features and functions available to help you manage your environment and ensure that you can perform adequate recovery of your data.

In this chapter, the concept of logging in a relational database system as it relates to the recovery of a database will be discussed. In addition, the major utilities involved in the area of database recovery, BACKUP and RESTORE, will be reviewed.

Database Recovery ...

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