It's all about the answers!

Ask a question

CLM 2012 (4.0), Tomcat and HADR (DB2)

Ken Werner (21225) | asked Aug 24 '12, 11:34 a.m.
Hi there,
Does anyone know if the automatic client re-routing feature in a HADR setup works when using Tomcat? What I observe in case of a takeover is that the CLM fails to connect to the database (SQLCODE -1776). It looks like CLM doesn't necessarily have an active JDBC connectionand and therefore it doesn't get the SQL-exception (SQLCODE -4498) that tells the CLM's DB2-JDBC driver about the alternate DB-server. Any attempt of the CLM to create a new connection to its configured DB host (the primary DB-node) fails.

Ken Werner commented Aug 24 '12, 11:35 a.m.

also see the comments at the end of the following article:

One answer

permanent link
Ken Werner (21225) | answered Aug 28 '12, 11:06 a.m.
Problem solved! : )
It turns out the JDBC Driver wants to connect to the alternate DB host directly which was prevented by a firewall in our case.

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.