Fixes are available
APAR status
Closed as program error.
Error 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: db2inst1 NODE : 000 DB : MYDB1 APPHDL : 0-3365 APPID: *LOCAL.db2inst1.200410074339 AUTHID : DB2INST1 HOSTNAME: myhost1 EDUID : 13809 EDUNAME: db2agent (MYDB1) 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 : <preformatted> 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
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v111m4fp6 or later * ****************************************************************
Problem conclusion
Upgrade to db2_v111m4fp6 or later
Temporary fix
Comments
APAR Information
APAR number
IT35954
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-02-18
Closed date
2021-02-18
Last modified date
2022-03-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022