IBM Support

IZ40382: UNIVERSAL JDBC DRIVER FAILS TO RESOLVE INDOUBT TRANSACTIONS WHEN MORE THAN ONE MEMBER OF A DB2/Z DATASHARING GROUP IS AVAILABLE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The "IBM Data Server Driver for JDBC and SQLJ" may fail to
    resolve an indoubt transaction when more than one member of a
    DB2/z data-sharing group is available and the indoubt
    transaction is reported on a different member than the reporting
    one.
    
    ----------------------------------------------------------------
    [ibm][db2][jcc][SQLException@22922292] java.sql.SQLException
    [ibm][db2][jcc][SQLException@22922292] SQL state  = null
    [ibm][db2][jcc][SQLException@22922292] Error code = -4203
    [ibm][db2][jcc][SQLException@22922292] Message    = Error
    executing XAResource.rollback().  Server returned XAER_PROTO.
    
    [ibm][db2][jcc][SQLException@22922292] Stack trace follows
    com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][t4][2041][11392]
    Error executing XAResource.rollback().  Server returned
    XAER_PROTO.
     at com.ibm.db2.jcc.b.ac.a(ac.java:2614)
     at com.ibm.db2.jcc.b.ac.b(ac.java:1125)
     at com.ibm.db2.jcc.b.ac.rollback(ac.java:1025)
     at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.rollback(WSRdbX
     at com.ibm.ws.Transaction.JTA.XARminst.rollback(XARminst.java:2
     at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecovery
     at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLo
     at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryMa
     at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManag
     at java.lang.Thread.run(Thread.java:810)
    ----------------------------------------------------------------
    
    The problem is caused by a defect which causes the
    commit/rollback is sent to the member which was used to retrieve
    list of indoubt transactions, not to the member specified in the
    indoubt transaction itself.
    

Local fix

Problem summary

  • USERS AFFECTED:
    Users running XA transactions against DB2/z sysplex using
    "IBM Data Server Driver for JDBC and SQLJ".
    
    PROBLEM DESCRIPTION:
    The "IBM Data Server Driver for JDBC and SQLJ" may fail to
    resolve an indoubt transaction when more than one member of a
    DB2/z data-sharing group is available and the indoubt
    transaction is reported on a different member than the reporting
    one:
    
    Error executing XAResource.rollback().  Server returned
    XAER_PROTO.
    
    PROBLEM SUMMARY:
    The commit/rollback is incorrectly sent to the member which was
    used to retrieve list of indoubt transactions, not to the member
    specified in the indoubt transaction itself.
    

Problem conclusion

  • First fixed in DB2 UDB Version 9, FixPak 5 (s080512).
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ40382

  • Reported component name

    DB2 CEE AIX

  • Reported component ID

    5765F3000

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-18

  • Closed date

    2009-12-16

  • Last modified date

    2009-12-16

  • 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

    DB2 CEE AIX

  • Fixed component ID

    5765F3000

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 910

Reference #: IZ40382

Modified date: 16 December 2009