Was this helpful?
Lockstat Command Output – Statistics by Lock Type
The "Statistics by lock type" subsection of the Locking System Statistics provides a breakdown of statistics by resource type, whereas the Locking System Summary is an accretion of statistics for all resource types. Only resource types on which lock requests were made are shown.
Here is sample output from this section:
Statistics by lock type:
 
DATABASE     Request lock            10        Re-request lock           0
             Convert lock             0        Release lock              8
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
TABLE        Request lock            50        Re-request lock          19
             Convert lock             0        Release lock              0
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
PAGE         Request lock           679        Re-request lock          34
             Convert lock             0        Release lock            546
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
BM_PAGE      Request lock           239        Re-request lock           0
             Convert lock          1102        Release lock             13
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
CREATE       Request lock           121        Re-request lock           3
             Convert lock             0        Release lock              0
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
CONFIG       Request lock           131        Re-request lock           0
             Convert lock             0        Release lock            123
             Lock wait                6        Convert wait              0
             Deadlock                 0        Convert deadlock          0
DB_TEMP_ID   Request lock             8        Re-request lock           1
             Convert lock             1        Release lock              7
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
SV_DATABASE  Request lock             8        Re-request lock           0
             Convert lock            14        Release lock              7
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
SV_TABLE     Request lock            36        Re-request lock           0
             Convert lock             0        Release lock             36
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
TBL_CONTROL  Request lock            18        Re-request lock           0
             Convert lock             0        Release lock             18
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
JOURNAL      Request lock             8        Re-request lock           0
             Convert lock             0        Release lock              7
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
OPEN_DB      Request lock            17        Re-request lock           0
             Convert lock            17        Release lock             15
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
CKP_DB       Request lock           178        Re-request lock          26
             Convert lock             0        Release lock              0
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock 0
BM_DATABASE  Request lock             2        Re-request lock           0
             Convert lock            14        Release lock              0
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
BM_TABLE     Request lock            15        Re-request lock           0
             Convert lock            57        Release lock              0
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
CONTROL      Request lock             7        Re-request lock           1
             Convert lock             2        Release lock              2
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
EVCONNECT    Request lock             1        Re-request lock           0
             Convert lock             0        Release lock              0
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
ONLN_MDFY    Request lock             1        Re-request lock           0
             Convert lock             0        Release lock              0
             Lock wait                0        Convert wait              0
             Deadlock                 0        Convert deadlock          0
Fields are as follows:
Request lock, Re-request lock, Convert lock, Release lock, Lock wait, Convert wait, Deadlock, and Convert deadlock are described under Lockstat Command Output – Locking System Statistics.
DATABASE
Database locks
TABLE
Table locks
PAGE
Page locks
BM_PAGE
Database page cache locks
CREATE
Create table
CONFIG
Database configuration file
DB_TEMP_ID
Temporary table ID generation
SV_DATABASE
Server database lock
SV_TABLE
Server table lock
TBL_CONTROL
Table DDL lock
JOURNAL
Database journal lock
OPEN_DB
Database open lock
CKP_DB
Database checkpoint
BM_DATABASE
Database cache lock
BM_TABLE
Table cache lock
CONTROL
Miscellaneous server control locks
EVCONNECT
Server-server events
ONLN_MDFY
Online modify
Other possible resource types:
CKP_CLUSTER
Checkpoints in a cluster
BM_LOCK
Shared cache lock
AUDIT
C2 security
ROW
Row lock
CKP_TXN
Database checkpoint synchronization
VAL_LOCK
Value lock
SEQUENCE
Sequence generator
XA_CONTROL
XA Distributed transactions
CSP
Cluster lock
CMO
Cluster management
MSG
Cluster messaging
TBL_MVCC
MVCC Table lock
Last modified date: 08/29/2024