O'Reilly logo

Understanding DB2®: Learning Visually with Examples, Second Edition by Dwaine R. Snow, Michael Dang, Xiaomei Wang, Raul F. Chong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required