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.
RESTORE
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 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.
