home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList