Considerations for IBM Db2 Analytics Accelerator compatibility of offload tables

Tools Customizer generates DDL that can be used to create DB2® offload tables, but those tables are not compatible with IBM® Db2 Analytics Accelerator.

If you want the Db2 offload tables that you create to be compatible with IBM Db2 Analytics Accelerator, you must customize and run the SAMPLIB member CQMIDAA (edit macro) which makes the CQMDDL compatible with IBM Db2 Analytics Accelerator. Then the modified CQMDDL can be executed to produce IBM Db2 Analytics Accelerator compatible Db2 tables. Additionally, a new LOAD job must be customized and used to replace the CQM@LDB2 job created by TCz. The SAMPLIB member for the replacement job is CQM@LIDA. For more information, see Offloading data to Analytics Accelerator.