Accelerate queries with IBM DB2 Analytics Accelerator for z/OS by using InfoSphere Optim Query Workload Tuner
From the developerWorks archives
Date archived: January 12, 2017 | First published: March 20, 2014
The IBM® DB2® Analytics Accelerator for z/OS® is a technical solution that runs certain types of SQL queries on a high-performance appliance on behalf of DB2 for z/OS. It can be challenging to determine which tables and SQL statements should be offloaded to the Analytics Accelerator, and to estimate CPU savings and performance improvement, before implementing the offload. With detailed examples, this article explains how you can meet these challenges by using InfoSphere® Optim™ Query Workload Tuner and Analytics Accelerator Studio and quickly improve the performance of your workloads.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.