PK85855: COM.IBM.DB2.JCC.A.SQLEXCEPTION CREATING NEW JCC CONNECTION

Fixes are available

APAR status

Closed as program error.

Error description

WebSphere Application Server is getting a new JCC Connection and
then invoking getJccSpecialRegisters(), which triggers the start
of a global transaction. The JCC trace shows that the runtime
subsequently attempted to issue a local Connection.commit(),
which is invalid when running in a gloabal transaction.

Here is the traceback from the attempted commit:
com.ibm.db2.jcc.a.SqlException: &#65517;jcc&#65529;&#65517;10115&#65529;&#65517;10306&#65529;&#65517;3.53.81&#65529;
Invalid
 operation: An invalid COMMIT or ROLLBACK has been called in an
XA
 environment during a Global Transaction. ERRORCODE=-4200,
 SQLSTATE=2D521
at com.ibm.db2.jcc.a.bd.a(bd.java:679)
at com.ibm.db2.jcc.a.bd.a(bd.java:60)
at com.ibm.db2.jcc.a.bd.a(bd.java:120)
at com.ibm.db2.jcc.a.jb.h(jb.java:907)
at com.ibm.db2.jcc.a.jb.p(jb.java:1025)
at com.ibm.db2.jcc.a.jb.rollback(jb.java:1015)
at com.ibm.db2.jcc.a.we.rollback(we.java:176)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.
   cleanupTransactions(WSRdbManagedConnectionImpl.java:4653)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.
   cleanup(WSRdbManagedConnectionImpl.java:3903)
at com.ibm.ejs.j2c.MCWrapper.cleanup(MCWrapper.java:1513)
at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:499)
at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:1814)
at
com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.java:23
58)
at com.ibm.ejs.j2c.ConnectionManager.
   initializeForUOW(ConnectionManager.java:1408)
at com.ibm.ejs.j2c.ConnectionManager.
   involveMCInTran(ConnectionManager.java:1092)
at com.ibm.ejs.j2c.ConnectionManager.
   allocateConnection(ConnectionManager.java:611)
at com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.
   getConnection(WSRdbConnectionFactoryImpl.java:525)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.
   checkBackendId(WSRelationalRAAdapter.java:207)
...

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  All users of IBM WebSphere Application      *
*                  Server V7.0 using IBM DB2 Driver for JDBC   *
*                  and SQLJ version 3.53.81 and higher.        *
****************************************************************
* PROBLEM DESCRIPTION: Invoking getJccSpecialRegisters()       *
*                      allocating connection triggers the      *
*                      start of a global transaction.          *
*                                                              *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
When getJccSpecialRegisters() is invoked while allocating a
new JCC connection, a global transaction is started by the
driver. A subsequent invocation of local Connection.commit()
causes the following exception:
BBOO0220E: J2CA0026E: Method addSync caught
javax.transaction.SystemException: ATRBEG Failed, RC = 1841
at
com.ibm.ws390.tx.NativeGlobalTransactionContext.create(NativeGlo
balTransactionContext.java:207)
at
com.ibm.ws.tx.jta.TransactionImpl.checkIfNativeTransactional(Tra
nsactionImpl.java:1591)
at
com.ibm.ws.tx.jta.TranManagerSet.registerSynchronization(TranMan
agerSet.java:669)
at
com.ibm.ejs.j2c.RRSGlobalTransactionWrapper.addSync(RRSGlobalTra
nsactionWrapper.java:227)
at
com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionMan
ager.java:1380)
at
com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionMana
ger.java:1092)
at
com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionM
anager.java:611)
at
com.ibm.ws.rsadapter.cci.WSRdbConnectionFactoryImpl.getConnectio
n(WSRdbConnectionFactoryImpl.java:525)

Problem conclusion

Global RRS transaction is suspended, so that we can perform
initialization commands on the new connection, and then
resuming the transaction afterwards.

APAR PK85855 is currently targeted for inclusion in Service
Level (Fix Pack) 7.0.0.5 of WebSphere Application Server V7.0.

Please refer to URL:
//www.ibm.com/support/docview.wss?rs=404&uid=swg27006970
for Fix Pack availability.

Temporary fix

Comments

APAR Information

APAR number
PK85855
Reported component name
WEBSPHERE FOR Z
Reported component ID
5655I3500
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-05-04
Closed date
2009-06-04
Last modified date
2009-08-03

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name
WEBSPHERE FOR Z
Fixed component ID
5655I3500

Applicable component levels

R700 PSY UK48200
UP09/07/27 P F907

Fix is available

Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS7K4U","label":"WebSphere Application Server for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 October 2021

Tips

PK85855: COM.IBM.DB2.JCC.A.SQLEXCEPTION CREATING NEW JCC CONNECTION

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R700 PSY UK48200

Fix is available

Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

Document Information

Share your feedback

Need support?