Recovery Concepts

Now that we have discussed how to make proper backups for our DB2 objects, and how the DB2 log is used, we will take a look at how to use those objects in the event of a recovery. We will also look at the various types of recoveries.

Table Space Recovery

The RECOVER utility is used to recover a table space. It is performed in two major phases: RESTORE and LOGAPPLY.


The RECOVER utility determines which full image copy is needed by looking at the rows in the SYSIBM.SYSCOPY catalog table. This full image copy is taken and merged with any incremental copies that are found in the SYSCOPY table, replacing any updated pages in the full copy. This provides the basis for the restoration of the table space. It is possible to use ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.