Locking / Locked Objects
Purpose
Locked objects view shows the list of objects that are subjects to locks in the currently connected database.
Screenshot
Metric shown
Application handle
A system-wide unique ID for the application.
Source: MON_GET_LOCKS(NULL, #MEMBER#).APPLICATION_HANDLE
Object type
The type of object against which the application holds a lock (for object-lock-level information), or the type of object for which the application is waiting to obtain a lock (for application-level and deadlock-level information).
Source: MON_GET_LOCKS(NULL, #MEMBER#).LOCK_OBJECT_TYPE
Table schema
Schema name of the object.
Source: SYSCAT.TABLES.TABSCHEMA
Table name
Unqualified name of the object.
Source: SYSCAT.TABLES.TABNAME
Lock name
The name of the lock.
Source: MON_GET_LOCKS(NULL, #MEMBER#).LOCK_NAME
Lock mode
The type of lock being held.
Source: MON_GET_LOCKS(NULL, #MEMBER#).LOCK_MODE
Original lock mode
The original lock mode before conversion.
Source: MON_GET_LOCKS(NULL, #MEMBER#).LOCK_CURRENT_MODE
Database member
The numeric identifier for the database member from which the data was retrieved for this result record.
Source: MON_GET_LOCKS(NULL, #MEMBER#).MEMBER