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****n(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****n(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****nEventProcessingL oop(ResultHandler.java:725)
at com.ibm.io.async.ResultHandler$2****n(ResultHandler .java:847)
at com.ibm.ws.util.ThreadPool$Worker****n(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****n(bb.java:34)
at java.security.AccessController.doPrivileged(Access Controller.java:241)
at com.ibm.db2.jcc.b.yb.a(yb.java:369)

have you verified if the instance is listening on correct/specified port and is it possible to connect from any client to this db
check db2set db2comm=tcpip
dbm cfg and svcename mapped to a port in /etc/services

"No route to host" hints at network configuration problems.

Hii guy przytula

thanks for ur quick reply. I tried changing the same but still the error persist:

Error :

L'op&#233;ration de connexion test pour la source de donn&#233;es SOADataSource sur le serveur server1 du noeud bpa-uzes1Node01 a &#233;chou&#233; avec l'exception suivante : 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. Consultez les journaux JVM pour obtenir plus de d&#233;tails.

Do u think is there anything related to the service policy manager. I have gone through it but that does not seem to be the problem.

thanks for ur reply . any quick hint or help will be appreciated.

thanks
mnr

hii

i have checked about the network connection also. I mean i can connect to the server machine . But when i try to connect Websphere Application Server V6.1 with DB2 V8.1 , cant connect and get a error.

mnr