DB2 Server for VSE & VM: Data Restore Guide

Chapter 11. Restoring Logical Elements

You can reload tables from DB2 archive in one of two ways:

• Use the TRANSLATE function to convert the DB2 archive into a format that will minimize the time required for RELOAD. The TRANSLATE function can be run offline, after you have taken the DB2 archive, while the database is up.
• Run the RELOAD directly from the DB2 archive tape. The archive tape will be read twice during RELOAD processing.

There is a trade-off between running the TRANSLATE function to improve RELOAD processing and reading the DB2 archive tape twice if the TRANSLATE is not done.

This chapter contains all of the steps necessary to reload a table. You can reload directly from a Data Restore archive file, produced either by the BACKUP, BACKUP FULL/INCREMENTAL, or UNLOAD function.

Step 1 describes how to use the TRANSLATE function. You can use TRANSLATE to convert a DB2 archive into a format that improves RELOAD processing time.

Step 2 shows how to restore portions of the database from a BACKUP or UNLOAD file using the RELOAD function. Use RELOAD to recover the following:

• Existing tables after deleting existing rows
• New tables after creating the table
• Rows in an existing table
• Tables with all of their associated indexes, referential integrity, views, grants, comments, and labels
• Tables to prepare for forward recovery from log files

Step 3 shows how to list the changes recorded in the log archives and the current log for the tables being reloaded.

Step 4 shows how to apply the changes from the log archives and the current log.

Note:

The reload process is done using DB2 commands, so this will create log records unless the RELOAD is run in single user mode with LOGMODE=N.