APAR status
Closed as program error.
Error description
This issue affect the DB2 Universal (JCC) JDBC driver. If a
routine is called within an XA unit of work, and that routine
performs a commit on return, that commit is outside the XA
transaction but the result is that the unit of work is closed on
the server side. Once an xa end is flowed to end the unit of
work, an XAER_NOTA (not a valid transaction) message will be
flowed back to the requestor.
In future, we will flow RDBCMTOK=False (RDB Commit OK = false)
at the start of the conversation, which will cause us to ignore
the commit reply returned by the server outside of the
transaction.
Local fix
Do not code stored procedures to commit on return.
Problem summary
This issue affect the DB2 Universal (JCC) JDBC driver. If a
routine is called within an XA unit of work, and that routine
performs a commit on return, that commit is outside the XA
transaction but the result is that the unit of work is closed on
the server side. Once an xa end is flowed to end the unit of
work, an XAER_NOTA (not a valid transaction) message will be
flowed back to the requestor.
Problem conclusion
In future, we will flow RDBCMTOK=False (RDB Commit OK = false
at the start of the conversation, which will cause us to ignore
the commit reply returned by the server outside of the
transaction.
Temporary fix
Comments
APAR Information
APAR number
IZ44627
Reported component name
DB2 CUE SOLARIS
Reported component ID
5724B6202
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-02-25
Closed date
2010-05-07
Last modified date
2010-05-07
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 CUE SOLARIS
Fixed component ID
5724B6202
Applicable component levels
R910 PSY
UP
R950 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
07 May 2010