How to Create HADR on IBM DB2

[Former Member]

Hi  Experts,

I have installed ERP EHP5 with db2 9.7 on HP-UX B.11. We are planing to setup HADR.

Is there any simple steps to setup HADR?

Thanks ,

Subhash N Bhalekar

[Former Member]

Hello Subhash,

You could also refer to the following steps to get this document:

https://service.sap.com/swdc
-> Installations and Upgrades
-> Installation and Upgrade Guides
-> SAP NetWeaver
-> SAP NetWeaver 7.0 (2004s)
-> Installation
-> 2 - Installation - SAP NetWeaver Systems
-> IBM Tivoli System Automation for MultiPlatforms-DB2 for LUW

You could refer to the info in this document to setup HADR in SAP environment.

Best Regards
Alfred

[Former Member]

Hello Subhash,

I think you could refer to the info of document 'IBM DB2 High Availability Solution: IBM Tivoli System Automation for Multiplatforms' to setup HADR with TSAMP in SAP environment. and you could
get this document with following link:

https://websmp208.sap-ag.de/~sapidb/011000358700000399902009E/samp_db6_new.pdf

Hope this could be helpful. Thank you.

Regards
Alfred

[former_member264034]

Hi,

Please see the following guides for HADR configuration:

Configure multiple HADR databases in a DB2 instance for
automated failover using Tivoli System Automation for Multiplatforms

http://www.ibm.com/developerworks/data/library/techarticle/dm-1409hadr-db2-tivoli/index.html

A step by step description can be found here:
http://www-01.ibm.com/support/docview.wss?uid=swg21410648

For more information about HADR please check the following wiki:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/page/HADR%20Tutorial

Regards,
Aidan

[Former Member]

Hi Aidan McKiernan,

Thanks for quick reply.

How many time take this activity for Primery Server to Standby Server ?

Thanks,

Subhash N Bhalekar

[former_member185954]

Hello Subhash,

Will it not depend on the following ?

- Your DB size

- Your network speed.

Regards,

Siddhesh

[former_member264034]

Hi Subhash,

I am not sure what your query regarding the time for activity is, can you elaborate, what exact activity, the configuration or the failover?

The details of initializing the standby database have been documented

in the following IBM guide:

Data Recovery and High Availability Guide and Reference

Could you please refer to it for the detailed steps?

ftp://ftp.software.ibm.com/ps/products/db2/info/vr97/pdf/en_US/DB2RecoveryAndHA-db2hae973.pdf

Regards,
Aidan