Chapter 13. Developing Database Backup and Recovery Solutions

A power failure may hit your database system while it is busy processing. A user may accidentally drop a very important table that you really need. How can you recover the table that has been dropped? What can you do to ensure that the data in the database remains consistent even when processing has been interrupted by a power failure? DB2's backup and recovery methods are designed to help you in those situations.

In this chapter you will learn about:

• The concept of transaction logging and the various logging methods

• How to perform backup operations

• How to perform restore operations

• How to perform roll forward operations

• How to inspect your databases for corruptions

• What split mirroring is

• What High Availability Disaster Recovery (HADR) is and how to set it up