Lock Object Name



Snapshot Level
Application
Lock
 


Logical Data Grouping
appl
appl_lock
lock


Monitor Switch
Lock
Lock
Basic


Resettable


No


 


Event Type
Deadlock


Logical Data Grouping
dlconn_event


 


Element Name
Element Type



lock_object_name
information

 

Description:  This element is provided for informational purposes only. It is the name of the object for which the application holds a lock (for object-lock-level information), or the name of the object for which the application is waiting to obtain a lock (for application-level and deadlock-level information).

Usage:  It is the name of the object for table-level locks is the file ID (FID) for SMS and DMS table spaces. For row-level locks, the object name is the row ID (RID). For table space locks, the object name is blank.

To determine the table holding the lock, use "Table Name" and "Table Schema Name" instead of the file ID, since the file ID may not be unique.

To determine the table space holding the lock, use "Table Space Name".