Command Reference

UPDATE HISTORY FILE

Updates the location, device type, or comment in a 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 an optional 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

TSM

U

User exit

O

Other.

COMMENT new-comment

Specifies a new comment to describe the entry.

Examples

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 history file is used for record keeping purposes only. It is not used during database recovery.

See Also

PRUNE HISTORY/LOGFILE.