DB2 - Problem description
Problem IT33355 | Status: Closed |
DEADLOCK BETWEEN INVALIDATION OF PACKAGE AND IMPLICIT REBIND OF THE SAME PACKAGE. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
This is reported originally as IT15631 and the code change is needed for V11.5. A deadlock is received in Purescale environment when 2 agents are accessing the same package, where an agent could be invalidating the package because of a change in the dependent objects and another agent could be implicitly rebinding the package during execution of the invalid package. Following is an example scenario: 1. Create a multi-partitioned table. 2. Create a procedure dependent on the paritioned-table. 3. Detach a partition, which will mark the procedure's PLAN invalid. 4. Running concurrent "call procedure()" and another detach might result in a deadlock scenario. The "call procedure()" would be doing an implicit rebind on the package. And the following is an example of lock information observed in this problem. Participant No 2 requesting lock ---------------------------------- Lock Name : 0x63413657455946672B247466EB Lock wait start time : 2016-05-27-02.17.12.360474 Lock wait end time : 2016-05-27-02.17.20.025958 Lock Type : GLOBAL_PKG Lock Specifics : Lock Attributes : 00040000 Lock mode requested : Exclusive Lock mode held : Exclusive Lock Count : 0 Lock Hold Count : 0 Lock rrIID : 0 Lock Status : Waiting Lock release flags : 00000000 Tablespace TID : Tablespace Name : Table FID : Table Schema : Table Name : Participant No 1 requesting lock ---------------------------------- Lock Name : 0x63413657455946672B247466C1 Lock wait start time : 2016-05-27-02.16.53.247656 Lock wait end time : 2016-05-27-02.17.20.025958 Lock Type : PLAN Lock Specifics : PACKAGE_TOKEN=cA6WEYFg,HashPkgID:6674242b,LoadingBit:0 Lock Attributes : 00000000 Lock mode requested : Exclusive Lock mode held : Exclusive Lock Count : 0 Lock Hold Count : 0 Lock rrIID : 0 Lock Status : Waiting Lock release flags : 00000000 Tablespace TID : Tablespace Name : Table FID : Table Schema : Table Name : | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.1 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.06.2020 09.04.2021 09.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |