Supported migration pathways for IBM Db2 Analytics Accelerator
The following IBM Db2 Analytics Accelerator migration pathways are supported for migrating data from 3.3.0 to 3.4.0.
| From | To | Scripts | Description |
|---|---|---|---|
| 3.3.0 accelerator shadow tables | 3.4.0 accelerator shadow tables | CQMIDAAL | You are upgrading from 3.3.0 to 3.4.0 and have offloaded your 3.3.0 data to accelerator. You want to offload to 3.4.0 accelerator tables and migrate your 3.3.0 accelerator data to 3.4.0. |
| Analytics Accelerator shadow tables with INTEGER columns (created Analytics Accelerator tables before PI83232) | Analytics Accelerator shadow tables with BIGINT columns (PI83232) | CQMIDAM1 | Required after applying PI83232, if you have offloaded to accelerator before this enhancement. |
| Existing Db2 offload tables | Analytics Accelerator shadow tables | CQMIDAM2 | Required if you intend to offload to Analytics Accelerator and want your old Db2 data to be migrated to Analytics Accelerator. |
| Existing Analytics Accelerator tables, created prior to PH17430 | Analytics Accelerator tables that have been updated with column formats required for anomaly detection and data collection | CQMIDAM3 | Required if you intend to offload to Analytics Accelerator and want to use anomaly detection and reporting. |