|
Problem IC63906
|
Status: Closed |
THROW WARNING FOR NON INSERT QUERIES, IF THE APPLN TRIES TO SET SQL_ATTR_PARAMOPT_ATOMIC AGAINST Z/OS SERVER |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When it comes to buffered inserts where the statement are not
exclusively insert, zOS servers do not support atomicity, and
within CLI, we will switch to chaining. However, chaining
(DRDA) is not atomic, thus if the app has not specified
non-atomic, we should be throwing a warning and switching off
the atomicity. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* When running non-insert queries with array buffers against *
* z/OS server and requesting atomicity. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When running non-insert queries(Update/Delete) with array *
* buffers against z/OS server and requesting atomicity, *
* internally the statement is executed non-atomically since it *
* switches to DRDA chaining. The user is not aware that the *
* execution was non-atomic. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v97fp1 or later. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in DB2 v97fp1. A warning will be thrown stating that the
execution will be non-atomic for non-insert queries with array
buffers since z/OS server doesn't support it. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.10.2009
08.02.2010
08.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
