hi everybody,
We have been facing a problem.
we are using WebSphere Application Server Platform 5.0 [BASE 5.0.0 s0245.03] and DB2 UDB 8.1 as the database. We want to use an XADatasource as we have to manage distributed transactions.
We have configured an XADatasoruce through websphere administrative console.
The implementation class is COM.ibm.db2.jdbc.DB2XADataSource and the datastore helper class com.ibm.websphere.rsadapter.DB2DataStoreHelper.
The following code looks up the datasource object and executes a sample query.


Properties p = new Properties () ;
p.put(Context.INITIAL_CONTEXT_FACTORY, "com.ibm.websphere.naming.WsnInitialContextFactory ");
Context context = new InitialContext(p);
DataSource xads= (DataSource)context.lookup("jdbc/testdb");
Connection con = xads.getConnection();
Statement stmt = xcon.createStatement();
stmt.executeQuery("select * from test_tbl");

and the following exception is thrown

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "326". Subcode = "". SQLSTATE=58005 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(Unknown Source) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source) at COM.ibm.db2.jdbc.app.DB2Statement.executeQuery(Unk nown Source) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQ uery(WSJdbcStatement.java:463) at org.apache.jsp._TestLookup._jspService(_TestLookup .java:151) at com.ibm.ws.webcontainer.jsp****ntime.HttpJspBase.se rvice(HttpJspBase.java:89) at javax.servlet.http.HttpServlet.service(HttpServlet .java:853) at com.ibm.ws.webcontainer.jsp.servlet.JspServlet$Jsp ServletWrapper.service(JspServlet.java:344) at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.ser viceJspFile(JspServlet.java:598) at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.ser vice(JspServlet.java:696) at javax.servlet.http.HttpServlet.service(HttpServlet .java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258) at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42) at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:79) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:199) at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:331) at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:432) at com.ibm.ws.http.HttpConnection****n(HttpConnection. java:343) at com.ibm.ws.util.ThreadPool$Worker****n(ThreadPool.j ava:592)

i tried looking for reason code 326 but found nothing.

Are there some more settings to be done on the database to make it work ?
I have already bound the follwing packages in the database
@db2cli.lst
@db2ubind.lst



Thanks & regards
Shamsur