Chapter 8. Recovery and Restart

• "Database recovery concepts

• Logging

• Image copies

• Data recoveries

• Disaster recoveries

• System-level backup/recovery

• DB2 restart

Database Recovery Concepts

DB2 has several methods for recovering data in the event of failures or when errors occur or disaster strikes. DB2 allows you to recover data to the current state or to an earlier state.

Many of the objects in DB2 can be recovered using various methods. You can recover

• Table spaces

• Index spaces

• Indexes

• Partitions of a table space

• Individual data sets

• Pages within an error range

• Individual pages

In order to ensure consistent operation and integrity of data, a DBA must develop a strategy for several recovery scenarios. These scenarios ...

Get DB2® for z/OS® Version 8 DBA Certification Guide 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.