|
Problem IT10270
|
Status: Closed |
An inplace table reorg may deadlock with a concurrent update operation |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A space-reclaiming inplace table reorg may deadlock with
a concurrent update operating on the same table.
This deadlock may not occur if the reorg is reclustering;
that is, there is a clustering index on the table, or the reorg
specified an index.
This problem exists on DB2 V9.7 GA to Fix Pack 10, V10.1 GA to
Fix Pack 5 and V10.5 GA. It does not exist on DB2 V10.5
Fix Pack 1 or later.
db2pd -eve shows a deadlock as below.
-----
Database Partition 0 -- Database SAMPLE -- Active -- xxx
Locks being waited on :
AppHandl [nod-index] TranHdl Lockname Type
Mode Conv Sts CoorEDU AppName AuthID AppID
43815 [000-43815] 222 000100D200000001000000006A Onl
Reorg .IN .IX C 6000 db2reorg DB2INST1 xxxxx
21003 [000-21003] 232 000100D200000001000000006A Onl
Reorg ..S G 891 db2jcc_a DB2INST1 xxxxx
43815 [000-43815] 222 000100D200000003DDAC002152 Row
.NS G 6000 db2reorg DB2INST1 xxxxx
21003 [000-21003] 232 000100D200000003DDAC002152 Row
..X W 891 db2jcc_a DB2INST1 xxxxx
-----
In above example, db2jcc_a runs UPDATE command while REORG is
executing as db2reorg. The deadlock is between the inplace
reorg lock and a row lock. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 UDB Version 9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 FixPack 11. *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 11. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.07.2015
07.10.2015
07.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
