Manual Scripts to Perform HADR Failover

[heartwork93]

I need to setup automating failover for live HADR clusters.
Environment: Windows 2008 R2 64 bit, DB2 v9.7 ESE FP 3a
It seems I cannot use a solution like Tivoli System Automation for Multiplatforms. (license issue)
I might need to implement manual scripts for doing this task asap ...
I searched through the internet and I did not find anything suitable ...
Is this possible to create .sql scripts or can you do this using Task Center by creating different tasks that perform some checks?
The big problem is what to check in order to decide when to perform the failover?
1. To check if you can connect to DB's
2. To connect and also to list applications to see if there are any applications running also?
(it is possible that applications run but you cannot connect ... different scenarios ... )
Also I am concerned in setting up for HADR: SYNC, NEARSYNC, ASYNC and HADR_PEER_WINDOW value...
(these are servers sitting in the same rack - recommended SYNC, two Ethernet connections)

 

[sathyarams]

http://www.dbforums.com/db2/1663997-manual-scripts-perform-hadr-failover.html

discussion on the same topic(same poster) here. Tek-tippers may have more to add

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp