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 IC87842 Status: Geschlossen

LOCK EVENT MONITOR RETURNED "LOCK MODE HELD : NONE".

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
Lock mode held none in the event monitor output should be 
incorrect. 
Incorrect Lock mode held output from db2evmonfmt. 
 
Here is the extract of the event monitor. 
 
As follows, when they couldn't catch the information of Lock 
Owner,  "Lock mode held none" was output in the event monitor. 
======================== 
------------------------------------------------------- 
Event ID               : 2 
Event Type             : LOCKTIMEOUT 
Event Timestamp        : 2012-03-15-20.53.25.932328 
Partition of detection : 0 
------------------------------------------------------- 
 
Participant No 1 requesting lock 
---------------------------------- 
Lock Name            : 0x00020004000000000000000054 
Lock wait start time : 2012-03-15-20.53.20.931148 
Lock wait end time   : 2012-03-15-20.53.25.932328 
Lock Type            : TABLE 
Lock Specifics       : 
Lock Attributes      : 00603000 
Lock mode requested  : Exclusive 
Lock mode held       : none 
Lock Count           : 1 
Lock Hold Count      : 0 
Lock rrIID           : 0 
Lock Status          : Converting 
Lock release flags   : 40000000 
Tablespace TID       : 2 
Tablespace Name      : USERSPACE1 
Table FID            : 4 
Table Schema         : DB2INST1 
Table Name           : TABLE1 
 
The problem only happen if the lock owner is not in the same 
member of the requester.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 UDB version 10.1 fix pack 1.                  * 
****************************************************************
Local-Fix:
Lösung
Problem was first fixed in DB2 UDB Version 10.1 Fix Pack 1.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.11.2012
13.11.2012
13.11.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version