Accelerate queries with IBM DB2 Analytics Accelerator for z/OS by using InfoSphere Optim Query Workload Tuner

From the developerWorks archives

Thuan Bui, Robert Heath, Leif Pedersen, and Chi Man Sizto

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=966209
ArticleTitle=Accelerate queries with IBM DB2 Analytics Accelerator for z/OS by using InfoSphere Optim Query Workload Tuner
publish-date=03202014