|
Problem IC61614
|
Status: Closed |
USING CLUSTERING INDEX, FOR SCENARIO THAT AN INSERT ROLLED BACK DUE TO LOCKTIMEOUT, DB2 MAY WAIT AS TWICE AS LOCKTIMEOUT VALUE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.06.2009
07.01.2010
07.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
