DB2 Help

Table Type

Snapshot Level Table	Logical Data Grouping table	Monitor Switch Table
Resettable	No
Event Type Table	Logical Data Grouping table_event
Element Name Element Type	table_type information

Description: The type of table for which information is returned.

Usage: You can 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 Name" to identify the table.

The type of table may be one of the following:

User table.
User table that has been dropped. The table type will only be updated after the changes are committed (either explicitly or implicitly).
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.
System catalog table.
Reorganization table. A table created and used by the database manager while performing a reorganization of another table.