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
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.