syslocks

The syslocks table provides information about all the currently active locks in the database server.
Table 1. syslocks table information

This table provides column, type, and description information for the syslocks table.

Column Type Description
dbsname char(128) Database name
tabname char(128) Table name
rowidlk integer Real rowid, if it is an index key lock
keynum smallint Key number of index key lock
type char(4) Type of lock
B Byte lock
IS Intent shared lock
S Shared lock
XS Shared key value held by a repeatable reader
U Update lock
IX Intent exclusive lock
SIX Shared intent exclusive lock
X Exclusive lock
XR Exclusive key value held by a repeatable reader
owner integer Session ID of the lock owner
waiter integer Session ID of the user waiting for the lock. If more than one user is waiting, only the first session ID appears.