Snapshot Information Level Table Space Application Lock |
API Structure(s) sqlm_tablespace sqlm_appl sqlm_appl_lock sqlm_lock sqlm_lock_wait |
Monitor Group Buffer Pool Basic Basic Lock Lock |
Resettable |
No | |
Event Information Level Deadlock Table Space |
API Structure(s) sqlm_dlconn_event sqlm_tablespace_header | |
API Element Name Element Type |
tablespace_name information |
Description: The name of the 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 manager 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. This element will be blank if the application is not waiting for a table space lock (see the "Lock Object Type Waited On" monitor element).
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.
If you are using the database system monitor APIs, note that the API constant sqlm_ident_sz is used to define the length of this element. Only the first 18 characters are currently used.
[ Top of Page | Table of Contents | Glossary | Index ]