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".