Snapshot Information Level Table Application Lock |
API Structure(s) sqlm_table sqlm_appl sqlm_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_schema information |
Description: The schema of the table.
Usage: Along with "Table Name", this element can help you determine the source of contention for resources.
For application-level, application-lock-level, deadlock-monitoring-level, this is the schema of the table that the application is waiting to lock, because it is currently locked by another application. This element is only set if "Lock Object Type Waited On" indicates that the application is waiting to obtain a table lock. For snapshot monitoring at the application-level and application-lock levels, this item is only valid when the "lock" monitor group information is turned on.
For snapshot monitoring at the object-lock level, this item is returned for table 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 element identifies the schema of the table for which information has been collected. This element is blank for temporary tables, reorganization tables, and tables that were dropped. Schema names are provided only for catalog and user tables. For snapshot monitoring, this element is valid only 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 8 characters are currently used.
[ Top of Page | Table of Contents | Glossary | Index ]