DB2 - Problem description
Problem IT02152 | Status: Closed |
XAER_PROTO. ERRORCODE=-4203, ERROR RETURNED WHEN FIRST QUERY FAILS IN A TRANSACTION. | |
product: | |
DB2 DATA SRVR D / DB2DSDRVR / A50 - DB2 | |
Problem description: | |
The issue happens starting with V10.1 FP3 driver (3.65.97 and 4.15.100 ) Steps to recreate . 1.Start a transaction . 2.Issue a select statement on a existing table . 3.Issue a select statement on a non existing table . 4.End Transaction . If first SELECT statement fails during a transaction ,the transaction fails with the above error. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users of IBM Data Server Driver for JDBC and SQLJ * * shipped with DB2 10.5 releases earlier than DB2 10.5 Fixpack * * 4 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 Fixpack 4 * **************************************************************** | |
Local Fix: | |
Solution | |
Upgrade to DB2 10.5 Fixpack 4 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2014 29.09.2014 29.09.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.4 |