DB2 FOR LUW / DB2FORLUW / 970 - DB2

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 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.7 FixPack 11 or higher              * 
****************************************************************

Problem was first fixed in Version 9.7 FixPack 11

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.02.2015
08.10.2015
08.10.2015

9.7.FP11