Q replication and HADR
We can combine Q replication and the High Availability Disaster Recovery (HADR) feature of DB2 in a couple of ways. In the first way, we can use Q replication to replicate data between database DB2A
and DB2B
and then use HADR to protect the DB2B
database, as shown in the following diagram:
There is a new Q Apply parameter in DB2 9.7 called LOADCOPY_PATH
, which can be used instead of the HADR DB2_LOAD_COPY_NO_OVERRIDE
registry variable when target tables are loaded by Q Apply using the DB2 LOAD
utility.
In the second way, we can use HADR to provide local resilience and Q replication to provide remote resilience, as shown in the following diagram: