Hi all

Where the db2 History file located in AIX
how can we recover that history file if it is corrupted.

I have idea we can recover that history file from backup image
is there any way from AIX team


Thanks and Regards

V.V.Prasad

I found it in Information Center:

The history file is individually restorable from any backup image. If the current database is unusable or not available, and the associated recovery history file is damaged or deleted, an option on the RESTORE command allows only the recovery history file to be restored. The recovery history file can then be reviewed to provide information on which backup to use to restore the database. For example, you can restore the history file for the sample database with this command:

db2 restore database sample history file

Hope it will help

thanks Markham

tell me the path of the history file

Check here:

http://publib.boulder.ibm.com/infoce.../c0005420.html

I found one of history file at DB2\NODE0000\SQL00001...