problem in connecting to DB2 V8.1 and WAS V6

[mayur1]

Hello everybody,

I am trying to connect to DB2 V 8.1 on Red Hat Linux V5 from WebSphere Application Server V6 on Windows Server 2003.

The problem that i am facing is that its not able to opent the socket on the port to communicate with the was and the db2.

here is the error i get:

[11/09/07 10:42:22:156 CEST] 00000043 ResourceMgrIm I WSVR0049I: Liaison de DefaultEJBTimerDataSource en tant que jdbc/DefaultEJBTimerDataSource
[11/09/07 10:42:22:171 CEST] 00000043 ResourceMgrIm I WSVR0049I: Liaison de SOADataSource_CF en tant que eis/jdbc/SOADB_CMP
[11/09/07 10:42:22:187 CEST] 00000043 ResourceMgrIm I WSVR0049I: Liaison de SOADataSource en tant que jdbc/SOADB
[11/09/07 10:42:43:250 CEST] 00000043 DSConfigurati W DSRA8201W: Configuration de la source de données (DataSource) : DSRA8040I: Impossible de se connecter à DataSource. Exception java.sql.SQLException rencontrée : [ibm][db2][jcc][t4][2043][11550] Exception java.net.NoRouteToHostException : Erreur lors de louverture du socket vers le serveur {1} sur le port {2} avec le message : {3}.DSRA0010E: Etat SQL = null, Code d'erreur = -4 499.
java.sql.SQLException: [ibm][db2][jcc][t4][2043][11550] Exception java.net.NoRouteToHostException : Erreur lors de louverture du socket vers le serveur {1} sur le port {2} avec le message : {3}.DSRA0010E: Etat SQL = null, Code d'erreur = -4 499
at com.ibm.db2.jcc.b.yb.a(yb.java:375)
at com.ibm.db2.jcc.b.yb.<init>(yb.java:76)
at com.ibm.db2.jcc.b.a.v(a.java:254)
at com.ibm.db2.jcc.b.b.a(b.java:1669)
at com.ibm.db2.jcc.c.p.a(p.java:350)
at com.ibm.db2.jcc.c.p.<init>(p.java:316)
at com.ibm.db2.jcc.b.b.<init>(b.java:290)
at com.ibm.db2.jcc.DB2PooledConnection.<init>(DB2Pool edConnection.java:67)
at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPoo ledConnectionX(DB2ConnectionPoolDataSource.java:14 4)
at com.ibm.db2.jcc.DB2ConnectionPoolDataSource.getPoo ledConnection(DB2ConnectionPoolDataSource.java:68)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(D SConfigurationHelper.java:1137)
at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:118)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPool edConnection(DSConfigurationHelper.java:1132)
at com.ibm.ws.rsadapter.DSConfigurationHelper.testCon nectionForGUI(DSConfigurationHelper.java:2355)
at sun.reflect.GeneratedMethodAccessor430.invoke(Unkn own Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at com.ibm.ws.management.DataSourceConfigHelperMBean. testConnectionToDataSource2(DataSourceConfigHelper MBean.java:532)
at com.ibm.ws.management.DataSourceConfigHelperMBean. testConnection(DataSourceConfigHelperMBean.java:46 0)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at sun.reflect.misc.Trampoline.invoke(MethodUtil.java :62)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unkno wn Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java :265)
at javax.management.modelmbean.RequiredModelMBean.inv okeMethod(RequiredModelMBean.java:1089)
at javax.management.modelmbean.RequiredModelMBean.inv oke(RequiredModelMBean.java:971)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke (DynamicMetaDataImpl.java:231)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDa taImpl.java:238)
at com.sun.jmx.interceptor.DefaultMBeanServerIntercep tor.invoke(DefaultMBeanServerInterceptor.java:833)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxM BeanServer.java:802)
at com.ibm.ws.management.AdminServiceImpl$1.run(Admin ServiceImpl.java:1055)
at com.ibm.ws.security.util.AccessController.doPrivil eged(AccessController.java:118)
at com.ibm.ws.management.AdminServiceImpl.invoke(Admi nServiceImpl.java:948)
at com.ibm.ws.console.core.mbean.ResourceMBeanHelper. testNode(ResourceMBeanHelper.java:810)
at com.ibm.ws.console.core.mbean.ResourceMBeanHelper. testConnection(ResourceMBeanHelper.java:256)
at com.ibm.ws.console.resources.database.jdbc.DataSou rceCollectionAction.execute(DataSourceCollectionAc tion.java:408)
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1486)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:528)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:118)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._ doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager .doFilter(WebAppFilterManager.java:696)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager .doFilter(WebAppFilterManager.java:641)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.h andleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:308)
at org.apache.struts.action.RequestProcessor.doForwar d(RequestProcessor.java:1070)
at org.apache.struts.tiles.TilesRequestProcessor.doFo rward(TilesRequestProcessor.java:273)
at org.apache.struts.action.RequestProcessor.processF orwardConfig(RequestProcessor.java:455)
at org.apache.struts.tiles.TilesRequestProcessor.proc essForwardConfig(TilesRequestProcessor.java:319)
at com.ibm.isclite.container.controller.InformationCo ntroller.processForwardConfig(InformationControlle r.java:159)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1486)
at org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:528)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:145)
at com.ibm.ws.console.core.servlet.WSCUrlFilter.conti nueStoringTaskState(WSCUrlFilter.java:371)
at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFil ter(WSCUrlFilter.java:229)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._ doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager .doFilter(WebAppFilterManager.java:696)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager .doFilter(WebAppFilterManager.java:641)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.h andleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.servlet.CacheServletWrappe r.handleRequest(CacheServletWrapper.java:92)
at com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:744)
at com.ibm.ws.wswebcontainer.WebContainer.handleReque st(WebContainer.java:1425)
at com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:92)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCa llback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListe ner.futureCompleted(AioReadCompletionListener.java :152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallbac k(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletio nActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture .java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHand ler.java:193)
at com.ibm.io.async.ResultHandler.runEventProcessingL oop(ResultHandler.java:725)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler .java:847)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:1498)
Caused by: java.net.NoRouteToHostException: No route to host: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl .java:372)
at java.net.PlainSocketImpl.connectToAddress(PlainSoc ketImpl.java:233)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.j ava:220)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:378)
at java.net.Socket.connect(Socket.java:536)
at com.ibm.db2.jcc.b.bb.run(bb.java:34)
at java.security.AccessController.doPrivileged(Access Controller.java:241)
at com.ibm.db2.jcc.b.yb.a(yb.java:369)
Edit/Delete Message


any urgent help is highly appreciated

thanks in advance

mnr

[docdiesel]

Hi,

looks like you need an update of the db2 driver / db2 runtime client. Find more information at http://publib.boulder.ibm.com/infoce...dsaccess3.html, look for "DSRA0010E".

Regards, Bernd

[mayur1]

hii,

thanks for ur reply. Could you please clarify more in detail.

I think there is some network configuration problem for accesing the db2 on other machine. But i am able to ping/telnet that system.

I have again configured the datasource and the jdbc drivers, deployed the application again on websphere but still the same error persist:

Error:

La connexion test pour la source de données Vigilance Data Source sur le serveur server1 au noeud bpa-srv-05Node01 a échoué avec l'exception suivante : java.lang.Exception: java.sql.SQLException: java.net.NoRouteToHostException : Error opening socket to server bpa-srv-06/192.168.4.245 on port 50000 with message : Aucun chemin d'accès pour atteindre l'hôte cible DB2ConnectionCorrelator: nullDSRA0010E: Etat SQL = null, Code d'erreur = -4 499. Consultez les journaux JVM pour obtenir plus de détails.

thanks in advance , any help appreciated

mayur

[docdiesel]

Hi Mayur,

I would go to command line / shell and try a "telnet 192.168.4.245 50000" to see if a connection is possible. A firewall in between may let a ping pass through but block a tcp connect.

Regards, Bernd