Snapshot Level Table Space Application Lock |
Logical Data Grouping tablespace appl_lock lock lock_wait |
Monitor Switch Buffer Pool Basic Lock Lock |
Resettable |
No | |
Event Type Deadlock Table Space |
Logical Data Grouping dlconn_event tablespace_header | |
Element Name Element Type |
tablespace_name information |
Description: The name of a table space.
Usage: This element can help you determine the source of contention for resources.
It is equivalent to the TBSPACE column in the database catalog table SYSCAT.TABLESPACE. At the application level, application-lock level, and deadlock monitoring level, this is the name of the table space that the application is waiting to lock. Another application currently holds a lock on this table space.
At the lock level, this is the name of the table space against which the application currently holds a lock.
At the table space level (when the buffer pool monitor group is ON), this is the name of the table space for which information is returned.