DB2 Backup & Restore Method

[Former Member]

Hi Gurus,

I have a source system which is ECC6 running on Windows Server 2008 & DB2 9.7 FP2 database. I want to build or copy the exact system to diffrent office. I have done a fulloffline backup on the server. The target system will be suselinux and same database which is DB9.7FP2.

So i have install a ECC6 system on the target system with same System ID,Hostname as the sourse system. . I am not sure what to do next. Please guide me how to restore the database using the full offline backup that i done on the sourse system.

Basically i am just doing a system copy but using the backup restore method.

[Former Member]

Hi,

Assuming you're performing system copy by using db2 backup/restore method.

If you would like to take a complete set of (online) backup image which you can restore, rollforward and bring the db into consistent state, you can use "INCLUDE LOGS" option of db2 backup command.

The backup image would include the range of log files required to restore and roll forward this image to some consistent point in time with this option.

On the other hand, you can specify a path to be searched for required logs during recovery. There's an option "OVERFLOW LOG PATH" for rollforward command.

For this issue u will get more information for below link

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp

REgards,

K.Ramamoorthy