Command Reference

UPDATE RECOVERY HISTORY FILE

Updates the location, device type, or comment in a recovery history file entry.

Authorization

One of the following:

sysadm

sysctrl

sysmaint

dbadm

Required Connection

Database

Command Syntax

>>-UPDATE HISTORY FOR--object-part--WITH------------------------> >--+-LOCATION--new-location--DEVICE TYPE--new-device-type--+--->< +-COMMENT--new-comment----------------------------------+

Command Parameters

FOR object-part

Specifies the identifier for the backup or copy image. It is a time stamp with a sequence number from 001 to 999.

LOCATION new-location

Specifies the new physical location of a backup. The interpretation of this parameter depends on the device type.

DEVICE TYPE new-device-type

Specifies a new device type for storing the backup. Valid device types are:

D

Disk

K

Diskette

T

Tape

A

ADSM

U

User exit

O

Other.

COMMENT new-comment

Specifies a new comment to describe the entry.

Example

To update the history file entry for the full database backup taken on April 13, 1997 at 10:00 a.m., enter:

   db2 update history for 19970413100000001 with
      location /backup/dbbackup.1 device type d

Usage Notes

The recovery history file is used for record keeping purposes only. It is not used during database recovery.

See Also

PRUNE HISTORY.

[ DB2 List of Books | Search the DB2 Books ]