DB2 Version 9.7 for Linux, UNIX, and Windows

table_file_id - Table file ID monitor element

The file ID (FID) for the table.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_TABLE table function - Get table metrics	Always collected
MON_GET_LOCKS table function - list all locks in the currently connected database	Always collected
MON_GET_APPL_LOCKWAIT table function - get information about locks for which an application is waiting	Always collected

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl	Lock
Table	table	Basic
Lock	appl_lock_list	Lock
Lock	lock	Lock

Table 3. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Deadlocks	lock	-

Usage

For snapshot monitoring, this element is provided for information purposes only. It 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 monitor elements to identify the table.

In MON_GET_LOCKS and MON_GET_APPL_LOCKWAIT table functions, this element represents the file ID (FID) for the table that the lock references.