Use shadow tables to get the performance benefits of BLU Acceleration for analytic queries in OLTP environments.
Shadow tables are implemented as materialized query tables (MQTs) that are maintained by replication. IBM InfoSphere Change Data Capture for DB2® for LUW (InfoSphere CDC), a component of IBM InfoSphere Data Replication, maintains shadow tables. To implement shadow tables in your environment, you must set up and configure all software components and replication, create the shadow tables, start replication to populate the shadow tables with data, and enable query routing to shadow tables.
To implement shadow tables:
After you implemented shadow tables, ensure that you maximize the performance benefits by tuning their performance. For more information, see Performance tuning for shadow tables.