Using SQL Replication with DB2's HADR

I get asked about this more than you'd think :) I've recorded the answer for anyone who's interested.

Update: If your DB2 has Tivoli System Automation (TSA), you can use TSA to assist with switching the SQL Replication programs when an HADR takeover occurs.

Views: 1504


You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Comment by david t on October 6, 2011 at 5:42pm
@Brian Fairchild, sorry I missed your comment so long ago.  I haven't tried it, but I don't believe you can expect to  a log capture program get changed data from DB2 on the standby.  The reason is that DB2's log read api is providing changed data found in DB2 log files.  However, the HADR standby is basically in roll forward pending as it applies log pages that come from the primary.  I believe that means the standby's log read api only provides changed data after an HADR takeover occurs.  Whatever the case, SQL Capture write to the source database.  If the standby is in read-only mode, then it can't work with the standby until after takeover.
Comment by david t on April 2, 2010 at 1:05am
Raghu, I'm glad to see someone else find this a handy combination :) Thanks for letting me know.
Comment by Raghu Cherukuru on March 31, 2010 at 6:03pm
hmmm You know what I just implemented this scenario. We are having SQL replication running and HADR running as well on the source database. I used automatic client re-route for HADR pair so that apply program can directly connect to the New Primary when Takeover happens.
Comment by prasad pigili on March 12, 2010 at 10:22pm
this is very useful to the people
Comment by david t on February 5, 2010 at 9:25pm
Hi, Brian, the simple answer is no. The longer answer is that the SQL Capture program needs to write to tables in the source database. For example, it updates its progress in its metadata (control) tables. More importantly, it stages changed data in tables in the source database. So, a read-only database won't do :)
Comment by Brian Fairchild on January 29, 2010 at 11:20am
Good info. I have another question you may know. With v9.7 fixpack 1 and a HADR readable standby database. Can we run SQL replication using the read-only standby as the source/capture server and apply it elsewhere , like a DW?

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service