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