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. What can you do to ensure that the data in the database remains consistent even when processing has been interrupted by a power failure? How can you recover a table that has been accidentally dropped? DB2’s backup and recovery methods are designed to help you in these situations.
In this chapter you will learn about:
The concept of transaction logging and the various logging strategies
How to perform a database backup
How to perform a database restore
How to perform a roll forward operation
How log shipping works
How split mirroring works and how ...