Database Reference
In-Depth Information
grant_bits : KJUSERNL KJUSEREX
grant mode : KJUSERNL KJUSERCR KJUSERCW KJUSERPR KJUSERPW KJUSEREX
count : 1 0 0 0 0 1
val_state : KJUSERVS_NOVALUE
valblk : 0x000000010c2799280000000000000000 .'(
...
Continuing the discussion, one lock has been granted and one lock is waiting as Cvting_locks is set to 1 and
Granted_locks is also set to 1.
Granted_locks : 1
Cvting_locks : 1
value_block: 00 00 00 01 0c 27 99 28 00 00 00 00 00 00 00 00
The following few lines show processes in the queue. The Granted_Q section prints the details about locks
currently held on the resource. Possible PID 13787 is holding an exclusive mode lock on this resource. Convert_Q
section prints the details about process waiting in the converting queue. Notice that there is no PID or XID
information printed in this lock structure, as that information is not available in the local node. You will need to refer
to the remote node LMD trace file to identify that information.
GRANTED_Q :
lp 1657e67440 gl KJUSEREX rp 17cfa16ca0 [0x1650015][0x351eac],[TX][ext 0x0,0x0]
master 1 gl owner 1753f447f8 possible pid 13787 xid 1007-0078-00001FF1 bast 0 ..
open opt KJUSERDEADLOCK
CONVERT_Q:
lp 16112f5ec8 gl KJUSERNL rl KJUSEREX rp 17cfa16ca0 [0x1650015][0x351eac],[TX]..
master 1 owner 2 bast 1 rseq 43 mseq 0x40001 history 0xd497adaa
convert opt KJUSERGETVALUE
LMD Trace File: Locks
The next section in the LMD trace file prints information about lock structures. Detail printed in this section is more
complete if the lock is held by a local session. Again, by assembling data from all nodes of LMD trace files, you can
get a complete picture about the deadlock issue.
The following section prints the data from enqueue structures. You can map lock pointers in the convert_q or
grant_q in the resource details section to the lock details section. In this example, lock 1657e67440 is holding the lock
and listed in grant_q section. This lock is also granted in exclusive mode as the grant_level is set to KJUSEREX. Process
with PID 13787 is holding the lock in exclusive mode.
----------enqueue 1657e67440------------------------
lock version : 185
Owner inst : 1
grant_level : KJUSEREX
req_level : KJUSEREX
bast_level : KJUSERNL
notify_func : 0
...
possible pid : 13787
xid : 1007-0078-00001FF1
...
 
Search WWH ::




Custom Search