Can I set up bidirectional Q-replication with both sender andreceiver server having HADR environment

[lltong]

Hi all,
I have 2 databases and both of them have db2 HADR set up. Now I will
need to set up the bidirectional Q replication between those 2
databases. Is it a environment supported by db2? I can only find a
redbook on unidirectional Q replication in HADR environment.
Thanks,
Lisa

[Steve Pearson (news only)]

Re: Can I set up bidirectional Q-replication with both sender andreceiver server having HADR environment

Yes, this should work. The Q-Rep activity needs to be set up between
the current primary databases, e.g., primary for db A and primary for
db B. When any HADR takeover occurs, Q-Rep needs to be restarted on
the new HADR primary.

I don't know Q-Rep well enough to talk to specifics on how to
configure it, but I suspect that if the HADR pairs sit locally, that
virtual IP addressing for each database might be helpful for Q-Rep's
reconnection after HADR takeover.

A primary <-------- Q-Rep -------- B primary
| |
HADR HADR
| |
v v
A standby B standby

Regards,
- Steve P.
--
Steve Pearson, DB2 for Linux, UNIX, and Windows, IBM Software Group
"Portland" Development Team, IBM Beaverton Lab, Beaverton, OR, USA