Can RTC be used against DB2 running HADR?

This is RTC 1.0.1

I don't think I've heard of anybody trying that setup before. Can you
provide a few more details about what doesn't work? Do you have any
error messages that might point us in the right direction?

-
Matt Lavin
Jazz Server Team


On Mon, 2009-04-06 at 18:07 +0000, wolfeb99 wrote:

We have a DB2 instance(9.5) running HADR -- we are having trouble
connecting to it from RTC. Has anyone successfully used this?

I think we have it under control -- we think it is a binding issue in db2. I will confirm after we try that.

We would like to setup a hot backup in case of site failure.

So far, we have 2 similar boxes setup in different physical locations each running RTC 1.0.1 on WAS and DB2 9.1 fp4. DB2 is setup with HADR. Each of the RTC instances points to the database using "//localhost:50000/JAZZ:fullyMaterializeLobData=false.....".

What we are seeing currently is that the primary instance works fine and the standby instance returns SQLCODE -1776. Our hope is that when the primary site failes, that the backup DB2 instance will then become active and the JDBC connection will be allowed from the backup RTC instance.

We are in the process of testing this today.

I'm interested to hear what you find in your testing. We didn't officially support that sort of deployment in 1.0.1, but I don't know of any problems with it either.

In 2.0 we are in the process of testing that sort of deployment, but we haven't used the DB2 HA support quite like you have.

Any luck trying this out?

Has anyone else implemented a DB failover solution?

Any luck trying this out?

Has anyone else implemented a DB failover solution?

Hello,

We, currently tested RTC2.0.0.2 and RTC3.0 with DB2 9.7 HA environment. Failover test cases worked well with no issues.



Myroslav Palenychka,

RSx SVT