Snapshot Information Level Table Application Lock |
API Structure(s) sqlm_table sqlm_appl sqml_appl_lock sqlm_lock sqlm_lock_wait |
Monitor Group Table Lock Lock Lock Lock |
Resettable |
No |
|
Event Information Level Table Deadlock |
API Structure(s) sqlm_table_event sqlm_dlconn_event |
|
API Element Name Element Type |
table_name information |
Description: The name of the table.
Usage: Along with "Table Schema Name", this element can help you determine the source of contention for resources.
At the application-level, application-lock level, and deadlock-monitoring-level, this is the table that the application is waiting to lock, because it is currently locked by another application. For snapshot monitoring, this item is only valid when the "lock" monitor group information is turned on, and when "Lock Object Type Waited On" indicates that the application is waiting to obtain a table lock.
For snapshot monitoring at the object-lock level, this item is returned for table-level and row-level locks. The table reported at this level is the table against which this application holds these locks.
For snapshot and event monitoring at the table level, this is the table for which information has been collected. This element is blank for temporary tables, reorganization tables, and tables that were dropped. Table names are only provided for catalog and user tables. For snapshot monitoring, this element is only valid when the "table" monitor group information is turned on.
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 ]