DB2 - Problembeschreibung
Problem IC61614 | Status: Geschlossen |
USING CLUSTERING INDEX, FOR SCENARIO THAT AN INSERT ROLLED BACK DUE TO LOCKTIMEOUT, DB2 MAY WAIT AS TWICE AS LOCKTIMEOUT VALUE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If the index is a clustering index, when we insert a row, there are the following steps involved: 1. We will perform a scan on the clustering index and try to cluster the row using the clustering index. 2. Once the row is inserted properly, we need to insert the key into index(es). When we insert the key into the clustering index, we will first try to avoid the index probe and try to insert the key directly onto the last index page we read during step 1. 3. We need to lock the next key during the insert, and if the next key is already locked in a mode that's not compatible with the insert, then we will attempt to reprobe from the root again. If the row lock is still not released during the reprobe, the insert will fail with a lock time out error. For the above scenario, DB2 waits as twice as locktimeout value. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error description field for more information. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.7 FixPack 1. * **************************************************************** | |
Local-Fix: | |
Not available | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 1. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.06.2009 07.01.2010 07.01.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |