Table Type

Snapshot Information Level
Table

API Structure(s)
sqlm_table

Monitor Group
Table

Resettable

No

Event Information Level
Table

API Structure(s)
sqlm_table_event

API 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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]