Topic
4 replies Latest Post - ‏2013-01-15T00:38:27Z by SystemAdmin
SystemAdmin
SystemAdmin
37426 Posts
ACCEPTED ANSWER

Pinned topic WAS6.1 connect to DB2 V8.1 error when using XA driver

‏2013-01-11T01:52:21Z |
Hello

Currently we encounter a problem that WAS6.1 configure JDBC when using XA driver and test JDBC connect to DB2 V8.1, it shows error:
Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x1801失败

13-1-10 17:28:20:544 CST 00000077 DSConfigurati W DSRA8201W: DataSource 配置:DSRA8041I: 无法连接到 DataSource。遇到 SQLException,SQL State = 58009,Error Code = -4,499 : Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x1801。
com.ibm.db2.jcc.b.DisconnectException: Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x1801
at com.ibm.db2.jcc.a.ab.l(ab.java:1214)
at com.ibm.db2.jcc.a.bb.Y(bb.java:1935)
at com.ibm.db2.jcc.a.bb.A(bb.java:3469)
at com.ibm.db2.jcc.a.fb.s(fb.java:507)
at com.ibm.db2.jcc.a.fb.e(fb.java:62)
at com.ibm.db2.jcc.a.c.jb(c.java:114)
at com.ibm.db2.jcc.a.c.n(c.java:450)
at com.ibm.db2.jcc.b.o.m(o.java:1127)
at com.ibm.db2.jcc.b.o.x(o.java:1319)
at com.ibm.db2.jcc.b.o.w(o.java:1306)
at com.ibm.db2.jcc.a.c.w(c.java:579)
at com.ibm.db2.jcc.b.wb.close(wb.java:65)
at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:2464)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:532)
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:460)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:62)
at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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.invokeMethod(RequiredModelMBean.java:1089)
at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:971)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:231)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:238)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:833)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:802)
at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1055)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.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.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:408)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.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.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(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.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:308)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1070)
at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:273)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:319)
at com.ibm.isclite.container.controller.InformationController.processForwardConfig(InformationController.java:159)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1486)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.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.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:371)
at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:229)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(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.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1425)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:92)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:193)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:725)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:847)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1498)
WebSphere Platform 6.1 http://ND 6.1.0.0 b0620.14 running with process name linuxNode02Cell\linuxNode02\server1 and process id 18062
Host Operating System is Linux, version 2.6.5-7.244-bigsmp
Java version = J2RE 1.5.0 IBM J9 2.3 Linux x86-32 j9vmxi3223-20060504 (JIT enabled)

I enclosed the picture and log file. Please help to check, thanks.
Updated on 2013-01-15T00:38:27Z at 2013-01-15T00:38:27Z by SystemAdmin
  • Sunit
    Sunit
    178 Posts
    ACCEPTED ANSWER

    Re: WAS6.1 connect to DB2 V8.1 error when using XA driver

    ‏2013-01-11T13:54:00Z  in response to SystemAdmin
    Which version of DB2 JDBC driver?

    --Sunit
    • SystemAdmin
      SystemAdmin
      37426 Posts
      ACCEPTED ANSWER

      Re: WAS6.1 connect to DB2 V8.1 error when using XA driver

      ‏2013-01-12T10:15:39Z  in response to Sunit
      Thanks, Sunit
      WSVR0049I: 将 Default_CF 绑定为 eis/DefaultDatasource_CMP
      13-1-10 17:28:19:823 CST 00000077 ResourceMgrIm I WSVR0049I: 将 utan_CF 绑定为 eis/utan_CMP
      13-1-10 17:28:19:828 CST 00000077 ResourceMgrIm I WSVR0049I: 将 Default Datasource 绑定为 DefaultDatasource
      13-1-10 17:28:19:834 CST 00000077 ResourceMgrIm I WSVR0049I: 将 utan 绑定为 utan
      13-1-10 17:28:19:886 CST 00000077 DSConfigurati W DSRA8200W: DataSource 配置:DSRA8020E: 警告:DataSource 类 com.ibm.db2.jcc.DB2XADataSource 上不存在属性“useTransactionRedirect”。
      13-1-10 17:28:20:363 CST 00000077 DSConfigurati I DSRA8203I: Database 产品名:DB2/LINUX
      13-1-10 17:28:20:364 CST 00000077 DSConfigurati I DSRA8204I: Database 产品版本:SQL08010
      13-1-10 17:28:20:364 CST 00000077 DSConfigurati I DSRA8205I: JDBC driver 名:IBM DB2 JDBC Universal Driver Architecture
      13-1-10 17:28:20:364 CST 00000077 DSConfigurati I DSRA8206I: JDBC driver 版本:2.3.63
      • Sunit
        Sunit
        178 Posts
        ACCEPTED ANSWER

        Re: WAS6.1 connect to DB2 V8.1 error when using XA driver

        ‏2013-01-14T14:49:51Z  in response to SystemAdmin
        http://www-01.ibm.com/support/docview.wss?uid=swg1LI70906

        -Sunit
        • SystemAdmin
          SystemAdmin
          37426 Posts
          ACCEPTED ANSWER

          Re: WAS6.1 connect to DB2 V8.1 error when using XA driver

          ‏2013-01-15T00:38:27Z  in response to Sunit
          Thanks a lot, Sunit