Question Re: DB2 Backup & Restore Method in Technology Q&A

DB2 Backup & Restore Method

Former Member — Fri, 05 Aug 2011 02:50:23 GMT

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.

Re: DB2 Backup & Restore Method

Former Member — Fri, 05 Aug 2011 04:46:26 GMT

Hi,

You cannot simply restore your database backup to different operating system. This is the case of OS migration as source and target OS are different. So, you need to carry out heterogeneous system copy. Check system copy guide on http://service.sap.com/instguides.

Thanks

Sunny

Re: DB2 Backup & Restore Method

Former Member — Sat, 06 Aug 2011 05:51:11 GMT

Hi ram,

As mentioned by sunny Its a heterogeneous system copy.

Even for homogeneous system for diff sid and hostname you need to create a control file

and need to do post activities also.

Here is heterogeneous system copy as ur source and target system environment is diff.

Pls go thro systemcopy guides in service market place and start the activity.

you can approach here if you get any issues during the process.

BR,

Kutty

Re: DB2 Backup & Restore Method

Former Member — Sat, 06 Aug 2011 06:02:58 GMT

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

Re: DB2 Backup & Restore Method

venkata_emandi — Sat, 06 Aug 2011 23:28:22 GMT

Hello,

Yes this is a heterogeneous system copy and you may have to get the migrations key.

Thanks

venkata

Re: DB2 Backup & Restore Method

Former Member — Mon, 08 Aug 2011 02:17:14 GMT

Hi All, .i was about to do a backup and restore method for this environment. But after going through the sap note below i believed it cant be done . So now i required to do a system export /import to bring it over to linux environment.

Note 628156 - DB6: Cross-Platform System Copy using Backup/Restore

However thanks everyone for the reply.appreciate it.