DB2 - Problembeschreibung
Problem IC76961 | Status: Geschlossen |
SIMULTANEOUS ADD PARTITION AND INSERT INTO EXISTING PARTITIONS MAY CAUSE DEADLOCK | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
Due to a small timing hole, an ADD PARTITION command can cause a deadlock if an insert into an existing partition of the same table is in progress. | |
Problem-Zusammenfassung: | |
Local-Fix: | |
Do not issue an ADD PARTITION and an insert into the same table simultaneously. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Kommentar | |
Back porting the fix from Galileo to fix this is desirable as some customers have hit similar issues. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 14.06.2011 07.12.2011 07.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |