DB2 Server for VSE & VM: Operation

SHOW LOCK GRAPH

Displays information about the lock dependencies between active database users.

Syntax

>>-SHOW LOCK GRAPH---------------------------------------------><

Description

This command shows you whether a user agent is waiting for a data space page fault. If it is waiting for a data space page fault, you will see DSPF in the WAIT STAT column.

Example

+--------------------------------------------------------------------------------+
|show lock graph                                                                 |
|LOCK       LOCK       WAIT  LOCK   DBSP   LOCKK     REQ    REQ                  |
|REQUESTER  HOLDER     STAT  TYPE   NUMBR  QUALFIER  STATE  MODE  DUR            |
|2   KEVIN  4   MARK   DSPF  DBSP   15               G WAIT S     LONG           |
|4   MARK   5   MIKE   LOCK  DBSP   16               G WAIT X     LONG           |
|5   MIKE   6   LAURA  LOCK  PAGE   21     88        G WAIT IS    LONG           |
|6   LAURA  1   STEVE  COMM  DBSP   1                G WAIT IX    LONG           |
|6   LAURA  3   GRANT  DSPF  DBSP   1                G WAIT IX    LONG           |
|ARI0065I Operator command processing complete                                   |
+--------------------------------------------------------------------------------+