Hi,

We have a DB2 on mainframe and a WebSphere Application Server on a
windows machine (Solaris as well).

We are using v5 datasources and regular JDBC works fine but now we need
to use XA to have 2 phase commit.

This seems to be harder than expected and the following error occurs:

//-- From the exception
Cannot get a connection from the database, configuration may be corrupt;
com.ibm.db2.jcc.c.SqlException: SQL1032N No start database manager
command was issued. SQLSTATE=00000

//-- From stdout
[2004-12-16 16:04:26:484 CET] 4e6982c2 FreePool E J2CA0046E: Method
createManagedConnctionWithMCWrapper caught an exception during creation
of the ManagedConnection for resource uchp/dtuchp, throwing
ResourceAllocationException. Original exception:
com.ibm.ws.exception.WsException: DSRA8100E: Unable to get a
XAConnection from the DataSource.
at
com.ibm.ws.rsadapter.exceptions.DataStoreAdapterEx ception.<init>(DataStoreAdapterException.java:244)


//-- Drivers
db2jcc.jar
db2jcc_license_cu.jar
db2jcc_license_cisuz.jar


datasourceHelperClassname="com.ibm.websphere.rsada pter.DB2UniversalDataStoreHelper"


name="databaseName" value="D2H0"
name="driverType" value="2"
name="serverName" value="v2101.volvo.se"
name="portNumber" value="460"
name="enableSQLJ" value="true"
name="traceLevel" value=""
name="traceFile" value=""
name="fullyMaterializeLobData" value="true"
name="resultSetHoldability" value="2"
name="currentPackageSet" value=""
name="readOnly" value="false"
name="deferPrepares" value="true"
name="currentSchema" value=""
name="cliSchema" value=""
name="enableMultithreadedAccessDetection" value="false"
name="retrieveMessagesFromServerOnGetMessage" value="true"
name="preTestSQLString" value=""

Can you assist me?

BR
Joacim J