System Copy/ Refresh on DB2

[Former Member]

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

AJ

[former_member188883 · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

please find the below link

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

regards,

balaram

[prjsyn_basisadmin]

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

[Former Member]

Hi PRJSYN,

Didnt you find the mentioned links useful in the blog.

Thanks

Ayush

[Former Member]

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

[Former Member]

Thanks for your suggestions Javier

[former_member182505]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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