2. Using Ingres Commands : lockstat Command—Display Locking Status : Lockstat Command Output – DLM Locks
 
Share this page                  
Lockstat Command Output – DLM Locks
The DLM Locks portion of the lockstat utility displays the cluster DLM (Distributed Lock Manager) view of the Ingres installation locks (grouped by resource).
Here is sample output from this section:
--------------- DLM Locks taken by Ingres instance CL ---------------
 
Locks by Resources having blocked lock(s)
  RqstNode           PID      Lock ID    Q GR RQ (MastNode:MastID)
LK_CSP,NODE=1,PID=0
  NODEA            2464D19B   47000C37 - G EX EX (NODEA:47000C37)
  NODEA            2464D19B   5B002C55 - W NL PR (NODEA:5B002C55)
  NODEB            24C34D01   4900C1FD - W NL PR (NODEA:61004665)
 
LK_CSP,NODE=1,PID=2464a9bb
  NODEA            2464A9BB   43006E07 - G EX EX (NODEA:43006E07)
  NODEA            2464D19B   7400381B - W NL PR (NODEA:7400381B)
  NODEB            24C34D01   0A006AED - W NL PR (NODEA:240057A6)
 
LK_CSP,NODE=2,PID=0
  NODEB            24C34D01   5900143D - G EX EX (NODEB:5900143D)
  NODEB            24C34D01   1900B776 - W NL PR (NODEB:1900B776)
  NODEA            2464D19B   2C000B37 - W NL PR (NODEB:46005BA6)
 
LK_CSP,NODE=2,PID=24c34d03
  NODEB            24C34D03   640055EB - G EX EX (NODEB:640055EB)
  NODEB            24C34D01   110038B8 - W NL PR (NODEB:110038B8)
  NODEA            2464D19B   22003414 - W NL PR (NODEB:4700B1B5)
 
LK_CSP,NODE=2,PID=24c34d04
  NODEB            24C34D04   6700CA0C - G EX EX (NODEB:6700CA0C)
  NODEB            24C34D01   7A00C422 - W NL PR (NODEB:7A00C422)
  NODEA            2464D19B   21005449 - W NL PR (NODEB:5700C08D)
 
Cluster Nodes seen
  Node Name     Node Number     Lock Count
  Local          00000000              0
  NODEA          00010023             13
  NODEB          00010026             17
Fields are as follows:
RqstNode
Node from which the lock was requested
PID
Process ID
Lock ID
Lock identifier
Q
Status of the lock:
G–granted
W–waiting
C–convert
GR
VMS lock mode granted:
NL–NULL
CR–Concurrent Read
CW–Concurrent Write
PR–Protected Read
PW–Protected Write
EX–Exclusive
RQ
VMS lock mode request (See GR above for lock mode explanations.)
MastNode:MastID
Master node and master lock ID