Supporting Db2 table types
This section lists the Db2 table types supported by Db2® Administration Foundation. It describes each table type and provides their access details. The Privileges tab is visible for view access, and the Data tab is visible for edit access.
| Table type | Table name | Description | Access (View/Edit) |
|---|---|---|---|
| C | Clone | A clone table is a copy of a base table that shares the same schema. It allows you to quickly switch between the base table and its clone, which is useful when updating the table or migrating the data. | View and Edit |
| D | Accelerator-Only | An accelerator-only table is designed for high-speed analytical queries and offloading complex workloads. | View only |
| G | Global Temporary | A global temporary table only exists for the duration of a session or a unit of work. | No applicable |
| H | History | A history table tracks the changes over time and contains historical rows that are no longer in the base table. | View only |
| M | Materialized Query | A materialized query table stores the results of a query and is used to optimize query performance. | View only |
| P | Implicit XML | An implicit XML table is automatically created to store XML data. It manages large XML objects separately for performance and storage efficiency. | No applicable |
| R | Archive | An archive table stores archived rows when used with archive-enabled Db2 functionality. It manages the data lifecycle and reduces the base table size. | View only |
| T | Table | A table stores relational data and forms the basis for most database operations. | View and Edit |
| X | Auxiliary | An auxiliary table stores Large Objects (LOB) or XML data associated with a base table. It enhances storage and performance by separating LOB or XML data from the base table. | Not applicable |