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 IT07402 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - 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 9.7 FixPack 11 or higher              * 
****************************************************************
Local Fix:
Solution
Problem was first fixed in Version 9.7 FixPack 11
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.02.2015
08.10.2015
08.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 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.