DB2 - Problem description
Problem IT38555 | Status: Closed |
DEADLOCK BETWEEN MANUAL RUNSTATS AND AUTO REORG RECLAIM ISSUED BY AUTO MAINTENANCE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Customers running on Db2 version before 11.5.6/11.5.7 could encounter a deadlock between Manual Runstats and Auto Reorg Reclaim. It raises an error SQL2310 Error -911. In case of this deadlock, instead of Auto Reorg Reclaim getting victimized, here Manual Runstats (higher priority than Auto Reorg Reclaim) was victimized and was rolled back. This should not happen. Error below gets reported in db2diag.log 2021-07-15-17.35.20.503231+120 I2195E673 LEVEL: Error PID : 3588 TID : 140059982423808 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : XXXXXXXX APPHDL : 0-13533 APPID: *LOCAL.db2inst1.210715153514 UOWID : 6 ACTID: 1 AUTHID : DB2INST1 HOSTNAME: XXXXXXX EDUID : 64 EDUNAME: db2agent (XXXXXXXX) 0 FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::fetch, probe:40 RETCODE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead lock detected" DIA8002C A deadlock has occurred, rolling back transaction. DATA #1 : Hex integer, 4 bytes 0x0000000D | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to 11.5.7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to 11.5.7 * **************************************************************** | |
Comment | |
upgrade to 11.5.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.09.2021 21.11.2021 21.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |