It's all about the answers!

Ask a question

Can RTC be used against DB2 running HADR?


Brian Wolfe (25613725) | asked Apr 06 '09, 2:03 p.m.
We have a DB2 instance(9.5) running HADR -- we are having trouble connecting to it from RTC. Has anyone successfully used this?

7 answers



permanent link
Brian Wolfe (25613725) | answered Apr 06 '09, 2:04 p.m.
This is RTC 1.0.1

permanent link
Matt Lavin (2.7k2) | answered Apr 06 '09, 2:24 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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?

permanent link
Brian Wolfe (25613725) | answered Apr 06 '09, 2:44 p.m.
I think we have it under control -- we think it is a binding issue in db2. I will confirm after we try that.

permanent link
Pravesh Patel (37612615) | answered May 16 '09, 12:21 p.m.
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.

permanent link
Matt Lavin (2.7k2) | answered May 18 '09, 4:47 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.

permanent link
Neil Plantan (1082215) | answered Nov 24 '09, 4:51 p.m.
Any luck trying this out?

Has anyone else implemented a DB failover solution?

permanent link
Myroslav Palenychka (51175) | answered May 17 '10, 10:43 a.m.
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

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.