Implementing shadow tables
Use shadow tables to get the performance benefits of BLU Acceleration for analytic queries in OLTP environments.
Before you begin
- Ensure that you are familiar with the software architecture for shadow tables. For more information, see IBM InfoSphere Change Data Capture software architecture and concepts for shadow tables.
- Ensure that you are familiar with the concepts related to the IBM® InfoSphere Change Data Capture (InfoSphere CDC) software. For more information, see IBM InfoSphere Change Data Capture software architecture and concepts for shadow tables.
- Ensure that you are familiar with the physical design guidelines for shadow tables. For more information, see Physical design for shadow tables.
About this task
Shadow tables are implemented as materialized query tables (MQTs) that are maintained by replication. IBM InfoSphere Change Data Capture for Db2® (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.
Procedure
To implement shadow tables:
What to do next
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.