DB2 - Problem description
Problem IT34500 | Status: Closed |
REORG RECLAIM CODE CAN LEAD TO DEADLATCH | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
With current code, a dead latch issue can be encountered. PROBLEM: Insert holding mTableWriter latch and request for BPD latch(X mode) for tuple state page when writing pages to buffer pool. However, reorg reclaim was having BPD latch on tuple state page(Shared mode) and requests for mTableWriter latch to get page compression HWM for a column. Hence, deadlatch was seen. SOLUTION: Code changed to avoid this issue. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v115m5fp0 or later * **************************************************************** | |
Local Fix: | |
Do not execute auto/manual runstats/reorg reclaim when concurrently running insert/update statement. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v115m5fp0 or later * **************************************************************** | |
Comment | |
Upgrade to db2_v115m5fp0 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.10.2020 19.11.2020 19.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |