syslocks
The syslocks table provides information about all
the currently active locks in the database server.
| 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. | |