Okie, now I know HADR is supposed to be a whizz to set up but I'm having some issues.
What I'm trying to do is have a Primary at one location and the standby in another location clear across the city (on a different subnet).
Now since this is on a SAN I want to do the log transfers over the management interface (each machine having 2 NIC and 2 IPs) rather than the interface used for production.
The issues I am having....
Firstly it seemed to get a bit precious over the host names and I had to use IP addresses in order to even get them to attempt to talk to each other. Now when we move into production I'd really rather not use IP addresses if at all possible. Any tips? Fully qualified names? Anyone else managed this?
Secondly is the issue with using the management interface, it tells me that the IP I've given it does not resolve to the server name. So I'm wondering where DB2 stores that server name and if it is possible to make an alias to allow it to recognise both interfaces as being on the server?
MESSAGE : HADR primary did not establish connection with standby within timeout
and will shut down. BY FORCE option required to start primary without
standby. Timeout seconds =
DATA #1 : Hexdump, 4 bytes
0x07800000318310C4 : 0000 0078