Question Re: System Copy/ Refresh on DB2 in Technology Q&A

System Copy/ Refresh on DB2

Former Member — Fri, 19 Apr 2013 07:58:27 GMT

Hi All,

Need your help and suggestions on how to perform System Copy/ Refresh on ECC6.0 on DB2 environment as this is my first time.

I am well aware of the system copies on Oracle environment but since i am novice on DB2 would really appreciate your help.

Step by step approach would be highly sppreciated.

Regards

Re: System Copy/ Refresh on DB2

Former Member — Fri, 19 Apr 2013 08:17:00 GMT

Hi Aayush,

Process is similar to oracle. We need to restore the database and recover it and then roll forward.

For detailed steps refer the link

http://www.ibm.com/developerworks/data/library/techarticle/dm-0911sapdb2redirectedrestore/index.html

Refer section Re-directed restore method.

Hope this helps.

Regards,

Deepak Kori

Re: System Copy/ Refresh on DB2

Former Member — Sun, 21 Apr 2013 22:02:54 GMT

Hi Aayush,

For which system you are looking to refresh is it ABAP only or ABAP+JAVA.

If ABAP+JAVA then you should go with export -import method.

Did you gone through with system copy guide for db2, If not first check go through with the guide and then prepare the plan.

Basically system refresh at db level is pretty much similar with both the database (oracle or db2).

You may perform refresh activity through SAPinst or simply restoring the database, but should aware what option you want ti opt as both have own adv & dis-advantage.

See the below link for system copy guide ...

https://websmp206.sap-ag.de/instguidesnw

Regards

Anuj

Re: System Copy/ Refresh on DB2

Former Member — Mon, 22 Apr 2013 08:18:35 GMT

Hi,

follow below link 100% correctly.

http://www.ibm.com/developerworks/data/library/techarticle/dm-0911sapdb2redirectedrestore/index.html

if any doubts please let me know.

regards,

balaram

Re: System Copy/ Refresh on DB2

Former Member — Tue, 23 Apr 2013 09:03:43 GMT

Hi Deepak,

Thanks for your reply and the link appears to be quite informative. I shall go through it and let you know in case of any doubts.

Regards

Ayush

Re: System Copy/ Refresh on DB2

Former Member — Fri, 17 May 2013 15:46:26 GMT

Hi,

Refresh can be done using Tape Restore or export/import method also

By which method you are trying to do it

Thanks & Regards

Amit Shedge

Re: System Copy/ Refresh on DB2

Former Member — Mon, 20 May 2013 06:31:31 GMT

Hi,

can you please send us your requirement, we can help you 100%.

1.which method about to use for Refresh (backup restore,export/import or any tools)

2.do you want any commands for your knowledge

please elaborate your post?

regards,

balaram

regards,

balaram

Re: System Copy/ Refresh on DB2

Former Member — Mon, 20 May 2013 09:13:27 GMT

Hi Balram,

In our ERP (ECC6.0 + AIX + DB2 v9.7) environment we use TSM for backups.

Client has sent us the document which had short procedure they use for system copy on DB2 and they want us to follow the same. But since we are new to DB2, finding it difficult to understantd.

They use Redirected Restore method.

I would like to attach the document to this post, but there is no provision (pls suggest how can i upload it )and if after going through it you could explain the steps then it would be a great help.

Awaiting your reply, its very urgent.

regards

ayush

Re: System Copy/ Refresh on DB2

Former Member — Mon, 20 May 2013 09:16:52 GMT

Hi Deepak,

Theres a document on DB2 redirected restore shared by our client, but since we are new to DB2 finding it hard to understand the steps mentioned in that. Let me know how can i share it with you so that you can explain the steps in that doc.

Awaiting your reply.

Regards

Ayush

Re: System Copy/ Refresh on DB2

Former Member — Mon, 20 May 2013 10:18:24 GMT

Hi,

please find the below link

http://public.dhe.ibm.com/software/dw/data/dm-0911sapdb2redirectedrestore/dm-0911sapdb2redirectedrestore-pdf.pdf

regards,

balaram

Re: System Copy/ Refresh on DB2

prjsyn_basisadmin — Fri, 04 Apr 2014 17:58:07 GMT

Hi Aayush,

Could you please help us have the Steps or any document related to the DB Refresh on ECC6 EHP6 on AIX / DB2.

Could you please send it to my email hussainsaber@gmail.com

Best Regards,

Saber H

M. +1 262 903 5876

Re: System Copy/ Refresh on DB2

Former Member — Mon, 21 Apr 2014 12:05:30 GMT

Hi PRJSYN,

Didnt you find the mentioned links useful in the blog.

Thanks

Ayush

Re: System Copy/ Refresh on DB2

Former Member — Mon, 21 Apr 2014 14:15:48 GMT

Hello Aayush,

in addition to the provided documentation, please also check SAP notes

888210 NW 7.**: System copy (homogeneously or heterogeneously using R3load)

7. Special Database Platform DB2 for LUW (DB6)

713524 DB6: Additional information on system copy with DB resources

regards,

Javier

Re: System Copy/ Refresh on DB2

Former Member — Tue, 22 Apr 2014 12:01:12 GMT

Thanks for your suggestions Javier

Re: System Copy/ Refresh on DB2

former_member182505 — Tue, 22 Apr 2014 14:06:00 GMT

HI Aayush

I would like to add a point please check the TSM parameter details and update it on db2 before doing restore and fallow the document given by Javier.

We will help you if you will get any issue.

Thanks

Sadiq

Re: System Copy/ Refresh on DB2

Former Member — Wed, 23 Apr 2014 17:09:05 GMT

you are welcome, don't forget to mark all the helpful answers