DB2 - Problembeschreibung
Problem IT07402 | Status: Geschlossen |
"DB2PD -LOCKS" output may display tranhdl as lock owner for locks being waited for | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 Version 9.7 FixPack 11 or higher * **************************************************************** | |
Local-Fix: | |
Lösung | |
Problem was first fixed in Version 9.7 FixPack 11 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.02.2015 08.10.2015 08.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |