Snapshot Information Level Application Table Lock |
API Structure(s) sqlm_appl sqlm_table sqlm_appl_lock sqlm_lock |
Monitor Group Lock Table Lock Lock |
Resettable |
No |
|
API Element Name Element Type |
table_file_id information |
Description: This is the file ID (FID) for the table.
Usage: This element is returned for compatibility with previous versions of the database system monitor, and it may not uniquely identify the table. Use "Table Name" and "Table Schema Name" to identify the table.
At the application level and application-lock level, this item is only valid when the "lock" monitor group information is turned on. The table reported at these information levels is the one that the application is waiting to lock, because it is currently locked by another application.
At the object-lock level, this item is always returned. The table reported at this level is the table against which this application holds table-level or row-level locks.
At the table level, this item is only valid when the "table" monitor group information is turned on.
[ Top of Page | Table of Contents | Glossary | Index ]