|
Problem IT17668
|
Status: Closed |
DEADLOCK BETWEEN APPLICATIONS ON DIFFERENT NODES WHILE IMPLICITLY REBINDING PACKAGE DURING EXECUTION |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Deadlock happened when two applications connecting to different
members execute the same package concurrently.
The package needs to be in invalid state before executing.
Implicit rebind will take place for the invalid package which
deadlocks
in a multi-node setup.
The following kind of deadlock event is observed in the
locking event monitor.
- Two participants execute same procedure.
- One participant was waited on PLAN LOCK
- Other participant was waited on ROW LOCK in SYSIBM.SYSPLAN |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* pureScale user. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V10.5 Fix Pack 9. *
**************************************************************** |
| Local Fix: |
Bind packages explicitly before executing the package. |
| Solution |
This problem is first fixed in V10.5 Fix Pack 9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.10.2016
27.09.2017
08.01.2018 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
