Snapshot Information Level Application Lock |
API Structure(s) sqlm_appl sqlm_appl_lock sqlm_lock |
Monitor Group Lock Lock Basic |
Resettable |
No |
|
Event Information Level Deadlock |
API Structure(s) sqlm_dlconn_event |
|
API Element Name Element Type |
lock_object_name information |
Description: 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: This element can help you determine the source of contention for resources.
The name of the object for table-level locks is the file ID (FID) for SMS 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".
The row ID is provided for information purposes only.
[ Top of Page | Table of Contents | Glossary | Index ]