|
Problem IC63906
|
Status: Geschlossen |
THROW WARNING FOR NON INSERT QUERIES, IF THE APPLN TRIES TO SET SQL_ATTR_PARAMOPT_ATOMIC AGAINST Z/OS SERVER |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
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 |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.10.2009
08.02.2010
08.02.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP1
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.1
|
 |
