DB2 Version 9.7 for Linux, UNIX, and Windows

table_type - Table type monitor element

The type of table for which information is returned.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Level
MON_GET_TABLE table function - Get table metrics	Always collected

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table	table	Basic

Table 3. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Tables	event_table	-

Usage

Use this element to help identify the table for which information is returned. If the table is a user table or a system catalog table, you can use table_name and table_schema to identify the table.

The type of table may be one of the following. The possible values are text strings based on defines in the sqlmon.h file.

USER_TABLE: User table.
TEMP_TABLE: Temporary table. Information regarding temporary tables is returned, even though the tables are not kept in the database after being used. You may still find information about this type of table useful.
CATALOG_TABLE: System catalog table.