You can display information on the current locks and lock requests on the database server in the Database Manager GUI.
The database instance is in the operational state ONLINE.
Choose Instance ® Information ® Locks.
The following information is displayed:
Max Entries |
Maximum number of locks held and requested |
Average Used Entries |
Average number of locks held and requested |
Collisions |
Number of collisions |
Escalations |
Number of escalations |
Row Locks |
Row locks currently held |
Table Locks |
Table locks currently held |
Request Timeout |
This indicates the time a task may wait for the setting of a requested lock before it is canceled. |