Tune DB2 for high performance: A case study

From the developerWorks archives

Bin Qiao

Date archived: January 13, 2017 | First published: July 28, 2011

Statistics show that database tuning can yield a 20% performance improvement over a system that has never been tuned. However, tuning a production system can be risky if not performed properly. This article demonstrates a real case study of database performance tuning in an IBM DB2® for Linux®, UNIX®, and Windows® environment. You can learn useful techniques to apply to your own database performance tuning.

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=748982
ArticleTitle=Tune DB2 for high performance: A case study
publish-date=07282011