Restoring the transaction logs
Perform this procedure if one of the following is true:
The archive logs did not originally reside on a raw device.
The user exit program was used to back up the archive logs.
To restore the transaction logs
- On the destination client, create a directory for the restored transaction log files.
For example:
Windows: mkdir C:\db\db2_v5\home\db2inst1\NODE0000\SQL00001\SQLOGDIR
UNIX: mkdir /db/db2_v5/home/db2inst1/NODE0000/SQL00001/SQLOGDIR
- Use the bprestore command to restore the logs.
For example:
Windows: bprestore install_path\db\db2_v5\home\db2inst1\ NODE0000\SQL00001\SQLOGDIR\S00001.LOG
UNIX: bprestore /db/db2_v5/home/db2inst1/NODE0000/SQL00001 /SQLOGDIR/S00001.LOG
- If the directory into which you restored the log files is not correct for the destination database, move the logs to the proper location.
- Verify that the correct owner and group permissions are enabled on the log directory.