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

Get DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition 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.