IT35954: MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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 is sysrouted FROM one or more of the following:

  IT33057

• 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