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 |