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 ...
Get Understanding DB2®: Learning Visually with Examples 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.
