DB2 - Problembeschreibung
Problem IC69160 | Status: Geschlossen |
ROLLBACK OF A SET OF MODIFICATIONS TO A DGTT CAUSES MEMORY CORRUPTION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
If a series of modifications to the definition of a declared global temporary table are made in the same transaction (e.g. create or drop index and/or runstats) and one of the create index statements fails, the rollback of the transaction may cause memory corruption. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Any. Requires use of Declared Global Temporary Tables * **************************************************************** * PROBLEM DESCRIPTION: * * If a series of modifications to the definition of a declared * * * * global temporary table are made in the same transaction * * (e.g. * * create or drop index and/or runstats) and one of the create * * * * index statements fails, the rollback of the transaction may * * * * cause memory corruption. * * * * Memory corruption may result in various traps/ABENDS either * * during rollback processing or subsequently. * **************************************************************** * RECOMMENDATION: * * Move to DB2 Version 9.5 fixpack 7. * **************************************************************** | |
Local-Fix: | |
Avoid errors on CREATE INDEX on declared global temporary tables; avoid issuing more than 1 create index/drop index and runstats on a declared global temporary table in a single transaction. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
DB2 Version 9.5 fixpack 7 includes the fix | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 10.06.2010 24.06.2010 24.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |