com.ibm.db2.jcc.am.XaException: XAER_NOTA failure during transaction start on XA resource in JBoss EAP

Solution Verified - Updated -

Issue

  • Multiple XA Resources referencing the same DB2 database
  • Occasionally, encountering the failure warning below during transaction start

    ... WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] ... IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@...: com.ibm.db2.jcc.am.XaException: [jcc][t4][10401][12066][4.22.29] XA exception: XAER_NOTA ERRORCODE=-4228, SQLSTATE=null
            at com.ibm.db2.jcc.am.ld.c(ld.java:561) [db2jcc4.jar:]
            ...
            at org.jboss.jca.adapters.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:259)
    

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP) 6
  • IBM DB2

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.