CLM 2012 (4.0), Tomcat and HADR (DB2)
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.
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.
Comments
Ken Werner
Aug 24 '12, 11:35 a.m.also see the comments at the end of the following article: https://jazz.net/library/article/464