DB2 Server for VSE & VM: Operation

SHOW LOCK ACTIVE

Displays locking information for active database users.

Syntax

>>-SHOW LOCK ACTIVE--------------------------------------------><

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 STATE column.

Example

+--------------------------------------------------------------------------------+
|show lock active                                                                |
|                 WAIT   TOTAL   LONG   WANTLOCK   WANTLOCK                      |
|AGENT   USER     STATE  LOCKS   LOCKS  TYPE       DBSPACE                       |
|1       JESSICA  I/O    140     100                                             |
|2       LEIGH    LOCK   226     220    DBSP       12                            |
|3       MARY     COMM   97      49                                              |
|4       MIKE     LOCK   108     101    DBSP       12                            |
|5       BOB      LOCK   107     98     PAGE       14                            |
|6       GENE     DSPF   88      44                                              |
|7       EDWIN    DSPF   101     28                                              |
|ARI0065I Operator command processing complete                                   |
+--------------------------------------------------------------------------------+