IBM Books

Administrative API Reference


Operational Hints and Tips

This section provides some hints and tips when building vendor products.

Recovery History File

A recovery history file can be used as an aid in database recovery operations. It is associated with each database and is automatically updated with each backup or restore operation. A general overview of the file is provided in the Administration Guide. The information in the file can be viewed, updated and pruned through the following facilities:

For information about the layout of the file, see db2HistData.

When a backup operation completes, a record or records are written to the file. If the output of the backup operation was directed to vendor devices, the DEVICE field in the history record will contain a O, and the LOCATION field will contain either:

See Invoking Backup/Restore Using Vendor Products for more details about specifying this option. If the vendor file name is not specified, LOCATION will be blank.

The LOCATION field can be updated using any of the above facilities. This capability can be utilized to update the location of the backup information if limited capacity devices (for example, removable media) have been used to hold the backup, and the media is physically moved to a different storage location (for example, off-site). If this is done, then this file can be utilized to assist in locating a backup when a recovery is necessary.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]