Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC74878 Status: Closed

DB2PD -LOCK SHOWLOCK WAIT MAY NOT SHOW ALL LOCK OWNER.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
When there are more than one lock owner and waiter, db2pd -lock 
showlock wait may not show some of the owner of the locks. 
 
For example, here is a case when there are two lock owners and 
waiters. 
db2pd -wlock shows two lock owners and two lock waiters as 
follows: 
Locks being waited on : 
AppHandl [nod-index] TranHdl ...  Type    Mode Conv Sts ... 
47       [000-00047] 16      ...  Row     ..X       G   ... 
51       [000-00051] 17      ...  Row     ..X       W   ... 
 
25       [000-00025] 2       ...  Row     ..X       G   ... 
47       [000-00047] 16      ...  Row     ..X       W   ... 
. 
However, db2pd -lock showlock wait only shows one owner: 
Locks: 
Address            TranHdl ...  Type Mode Sts Owner 
0x07000000405DE380 17      ...  Row  ..X  W   16   TbspaceID 2 
TableID 5 ... 
0x07000000405DE200 16      ...  Row  ..X  W   2    TbspaceID 2 
TableID 4 ... 
0x07000000405D6780 2       ...  Row  ..X  G   2    TbspaceID 2 
TableID 4 ...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using db2pd -lock showlock wait                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error description field for more information.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 FixPack 8.                            * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 UDB Version 9.5 FixPack 8.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
07.03.2011
07.07.2011
07.07.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.