O'Reilly logo

DB2® Universal Database for OS/390® Version 7.1 Certification Guide by Susan Lawson, Richard Yevich

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

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

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