DB2 - Problem description
Problem IT33057 | Status: Closed |
MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Multiple rebind package may encounter deadlock. Here is a sample from db2diag.log 020-04-10-16.32.36.347796+540 I355336A2956 LEVEL: Event PID : 19005480 TID : 13809 PROC : db2sysc 0 INSTANCE: e105q4sa NODE : 000 DB : DEADLOCK APPHDL : 0-3365 APPID: *LOCAL.e105q4sa.200410074339 AUTHID : E105Q4SA HOSTNAME: athena EDUID : 13809 EDUNAME: db2agent (DEADLOCK) 0 FUNCTION: DB2 UDB, lock manager, sqlplWaitOnWP, probe:999 MESSAGE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead lock detected" DIA8002C A deadlock has occurred, rolling back transaction. DATA #1 : Caught rc 0x80100002. Dumping stack trace. CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000009E5FE2B0 pdLogPrintf + 0x28 [1] 0x090000009DA78FF8 sqlplWaitOnWP__FCP9sqeBsuEduCP14SQLP_LOCK_INFOCP8SQLP_LRBCP15SQL P_LTRN_CHAINCbN25 + 0xD28 [2] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF [3] 0x090000009DACCEE4 sqlplWaitOnWP__FCP9sqeBsuEduCP14SQLP_LOCK_INFOCP8SQLP_LRBCP15SQL P_LTRN_CHAINCbN25 + 0x29A4 [4] 0x090000009DD2CDFC sqlplrq__FP9sqeBsuEduP14SQLP_LOCK_INFO + 0x1AE8 [5] 0x090000009DD2DB74 sqlplrq__FP9sqeBsuEduP14SQLP_LOCK_INFO + 0x2860 [6] 0x090000009DD33910 sqlrr_get_lock__FP8sqlrr_cbP14SQLP_LOCK_INFOUiPUi + 0x1BC [7] 0x090000009D686AB4 sqlra_pkg_lock__FP8sqlrr_cbPUcsT2T3T2UlUiiP14SQLP_LOCK_INFO + 0x170 [8] 0x090000009B64B644 sqlra_execute_event__FP8sqlrr_cbP20SQLR_RPC_APM_REQUEST + 0xF3C [9] 0x090000009B645EC8 sqlra_execute_event__FP8sqlrr_cbP20SQLR_RPC_APM_REQUEST + 0x274 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to V11.1 M4 FP6 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to V11.1 M4 FP6 * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2020 18.02.2021 18.02.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |