Ive been trying to turn on automation for NIC failover (Virtual Ip address) for HA for an application db2 9.7 on server 2008.

For two databases 1(win2008) and 2(win2008).

HADR works well Primary -> secondary in peer. Beautiful.

the issue is db2haicu doesnt work i mean i get nothing! (from doco example!)

1. db2pd –hadr –db database name (works fine!)

2. preprpnode hadr01 hadr02 (does nothing!)

3.db2 update alternate server for database
hadrdb using hostname 9.26.124.22 port 55445 (works fine!)

DB"D:\IBM\SQLLIB\BIN>db2haicu
'db2haicu' is not recognized as an internal or external command,
operable program or batch file." (does nothing!)

I cant find anything online about this issue what have i missed db2haicu will not start!

any help would be greatly appreciated!!!

Hi,

afaik db2haicu does not exist for Windows.

http://public.dhe.ibm.com/software/d...dr_tsa_win.pdf
IBM DB2 9.7 for Linux, UNIX and Windows Information Center

And also
IBM DB2 9.7 for Linux, UNIX and Windows Information Center

You get these agents packaged only with 9.7 FP4. earlier versions - you must get from the info centre

I have used only the db2 9.5 tsa agents for windows(as documented in the pdf above). That had a few bugs/limitations.

One of them was the absence of PEER WINDOW ONLY usage in the hadr start script.

Cheers
Sathyaram

Thankyou so much for your help everyone.

Im reading and testing Tivoli Systems automation as an option using HADR appreciate the help.

Ben

On Windows it is recommended to use Microsoft Cluster Server as the cluster management solution.