home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 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

DB2 - Problem description

Problem IT09683 Status: Closed

"DB2PD -LOCKS" output may display tranhdl as lock owner for locks
being waited for

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
Under certain circumstances,  "db2pd -locks" output may show 
the same value for both the lock owner and the transaction 
handle while the status is "Waiting". 
 
This can happen because db2pd does not take latches while 
collecting data.  It is possible and expected that db2pd may 
access data that is changing and therefore cannot be retrieved 
or may not be completely accurate. 
 
While efforts are made to determine the actual lock owner, 
if the value cannot be determined at the time the data is 
collected, 
then the transaction handle is displayed instead. 
 
The lock owner can be determined from the output by finding the 
entry for the lock name with a status of 'G' for 'granted'. 
 
Locks: 
TranHdl Lockname                   Type Mode Sts Owner Dur 
HldCnt ... 
3       00020002000000040000000052 Row  ..X  G   3     1   0 
... 
2       00020002000000040000000052 Row  ..X  W*  2     1   0 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 10.5 FixPack 7 or higher              * 
****************************************************************
Local Fix:
Solution
Problem was first fixed in Version 10.5 FixPack 7
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
25.06.2015
20.01.2016
20.01.2016
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7 FixList