DB2 Server for VSE & VM: Data Restore Guide

Chapter 9. Restoring an Entire Database or an Entire Storage Pool

This chapter shows how to restore either an entire database or only damaged storage pools, when a database is damaged. If the database becomes corrupted, or one of the disks on which it resides is damaged, the database cannot be used. As a result, it is extremely important that the database administrator recover the lost data from a database archive, either by restoring a full database archive or by restoring specific storage pools.

The RESTORE function of Data Restore can restore databases from TRANSLATED DB2 Server for VSE & VM database archives and Data Restore archives. While you may want to do DB2 Server for VSE & VM database archives rather than Data Restore archives (for example, you may want to take a database archive without bringing down the database), the RESTORE function has the fastest performance when processing its own archive tapes. If you want to use the DB2 Server for VSE & VM database archives but also want to improve the performance of the RESTORE function, you must use the TRANSLATE function to convert the DB2 Server for VSE & VM database archives to the Data Restore archive format.

In performing this function, the DBA does the following steps:

1. Stops the application server, if it is still running.
2. Decides whether or not to restore from the last archive.
3. Determines whether a physical error is on the disk requiring a reformat of a dbextent.
4. Determines if it is necessary to restore the entire database or to restore only some storage pools
5. Starts the RESTORE function.
6. Determines whether a log recovery is also necessary.

Note:

For pool recovery, the archive used as the base for pool recovery must include the current log in its restore set. If you are running in LOGMODE=A, only the most recent archive can be used. If you are running in LOGMODE=L, any archive may be used as long as the restore set is continuous and includes the current log. For example, if a COLDLOG is performed after the archive was taken, the COLDLOG breaks the continuity of the restore set for this archive, and so this archive can not be used for pool recovery.