|
Problem IT15338
|
Status: Closed |
NO AUTOCOMMIT FOR "COMMIT ON RETURN NO" STORED PROCEDURES FOR XASINGLE PHASE |
| product: |
DB2 JDBC SQLJ D / DB2DSDRVR / A50 - DB2 |
| Problem description: |
Type-4 connectivity: A SQL stored procedure having clause
"COMMIT ON RETURN NO" on z/OS V11 data server fail to commit
data when the procedure called from java application with XA
single phase protocol and autoCommit(true) which result in data
inconsistency. The issue has been fixed (RTC 88391) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users using driver releases older than 3.69/4.19 *
****************************************************************
* PROBLEM DESCRIPTION: *
* Type-4 connectivity: A SQL stored procedure having clause *
* "COMMIT ON RETURN NO" on z/OS V11 data server fail to commit *
* *
* data when the procedure called from java application with XA *
* *
* single phase protocol and autoCommit(true) which result in *
* data *
* inconsistency. The issue has been fixed (RTC 88391) *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V10.5 fIxpack 8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
Upgrade to DB2 V10.5 fIxpack 8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.05.2016
06.01.2017
06.01.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
