DB2 - Problembeschreibung
Problem IC89412 | Status: Geschlossen |
READ STABILITY ISOLATION IS NOT ENFORCED UNDER CERTAIN SQL ACCESS PLANS | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In SQL access plans where a table is accessed at least twice, the DB2 server might not retain locks required to preserve read stability during the entire SQL execution. Locks might be released for rows that satisfy matching criteria on the first access, and requested and held later only as the rows are retrieved by the application. Symptoms might include lost updates, duplicate row retrievals across applications, and inconsistent results within a transaction. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7.0.8. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
The problem if first fixed in DB2 version 9.7.0.8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC89415 IC89416 IC89934 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.01.2013 25.03.2013 26.03.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.0.8 | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |