Shadow tables

Shadow tables are replication-maintained, column-organized materialized query tables (MQTs). Shadow tables handle analysis queries within an online analytical processing (OLAP) transactional environment to accelerate query response. Shadow tables are also known as row-organized materialized query tables in DB2 environments.

Restrictions

Shadow tables have the following restrictions: The primary keys used in shadow tables have the following restrictions:

Feedback