Optimize DB2 10.5 for Linux, UNIX, and Windows performance using InfoSphere Optim Query Workload Tuner with the DB2 BLU accelerator feature

Getting recommendations for column organization conversion

From the developerWorks archives

Thuan Bui and Soid Quintero

Date archived: January 13, 2017 | First published: June 27, 2013

The new BLU Acceleration feature in IBM® DB2® 10.5 for Linux®, UNIX®, and Windows® can help improve the performance of your workload by converting row-organized tables to column-organized tables. However, the challenge is to know what tables could be converted and how much performance would improve. In this step-by-step article, you will learn how to use Optim Query Workload Tuner to perform column organization conversion, analyze what-ifs, and improve the performance of your workload.

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=935317
ArticleTitle=Optimize DB2 10.5 for Linux, UNIX, and Windows performance using InfoSphere Optim Query Workload Tuner with the DB2 BLU accelerator feature
publish-date=06272013