about updating history file during incremental auto restore
sandee...@gmail.com
I am restoring database (new db ) with incremental AUTO option
with redirect restore. but the backup images are from production while
restoring them in development. So history file needs to be updated
because AUTO option will read it from there. So I have to update the
backup image location in history file. please suggest how to update
and at what time during redirect restore ?
If i am not updating history file it is giving error :-
SQL2036N The path for the file or device "/bk01" is not valid.
The file location "/bk01" is present in PROD where the backup was
taken but the same location is not present in development.
ibm-db2
Sandeep,
You can try updating history:
UPDATE HISTORY FILE Command
Updates the location, device type, or comment in a history file
entry.
Command syntax
>>-UPDATE HISTORY--+-9 FOR--9 object-part-+--WITH------------------->
'-9 EID--9 eid---------'
>--+-LOCATION--new-location--DEVICE TYPE--new-device-type-+----><
+-COMMENT--new-comment---------------------------------+
'-STATUS--new-status-----------------------------------'
Examples
To update the history file entry for a 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 primary purpose of the database history file is to record
information, but the data contained in the history is used directly by
automatic restore operations. During any restore where the AUTOMATIC
option is specified, the history of backup images and their locations
will be referenced and used by the restore utility to fulfill the
automatic restore request. If the automatic restore function is to be
used and backup images have been relocated since they were created, it
is recommended that the database history record for those images be
updated to reflect the current location. If the backup image location
in the database history is not updated, automatic restore will not be
able to locate the backup images, but manual restore commands can
still be used successfully.
On Mar 3, 5:11 pm, "sandeep.i...@gmail.com" <sandeep.i...@gmail.com>
wrote: