No matter how careful you are, disasters can strike your data. You may
have to deal with media and storage problems, power interruptions, and
application failures. This SmartGuide will help you deal with basic
database recovery. (If you find that you have a more complex problem to
deal with, use the database restore dialog and consult the DB2 Administration
manual.)
Rebuilding a database is called recovery and there are three stages to a full recovery: crash recovery, restore, and roll-forward.
DB2 automatically takes care of crash recovery. If your database system crashes due to a software problem or power failure, the database manager will automatically restore your database. It uses a set of logs to record every transaction that has not yet been saved to permanent storage (hard drive). In the event of a power failure, it uses these logs to return your database to its state just after the last complete transaction.
If the hard drive that stores your database has crashed or the data has been accidentally erased, you need to restore your database from a backup image. The Backup History page of this SmartGuide contains a list that records database backups. Select a database image and click on Done.
If you enabled log archiving, you will also be able to roll-forward, or reapply, the changes stored in the logs. This means that you will be able to return the database to its state just after the last complete transaction, even if you are dealing with a hard drive crash.
Tasks
Page controls
Fields and controls
Related information