Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2007
    Posts
    5

    Unanswered: Problem in connecting to DB2 V8.1 on Linux

    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)

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    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
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    "No route to host" hints at network configuration problems.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Sep 2007
    Posts
    5
    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

  5. #5
    Join Date
    Sep 2007
    Posts
    5
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •