DB2 LUW Technote Tip for Linux

I've recently been doing some tuning for various customers on Linux. While I've focused primarily on zLinux in the past, this particular tip is for Linux on AMD Operton. But, I thought it was worth noting an I hope that if this matches your particular environment, you also find it helpful

Symptom

Slower OLTP workload performance running on Linux RHEL on AMD, when HPET (high precision event timer) is disabled in the operating system.

The details of this technote can be found here:


http://www-01.ibm.com/support/docview.wss?uid=swg21443045&myns=swgimgmt&mynp=OCSSEPGG&mync=E


Continued and Happy Tuning...

OPM Workshop on DB2 Performance - Columbus, Ohio May 12th

If you will be in the Columbus area, we will be hosting a DB2 Performance Workshop with Optim Performance Manager (OPM) May 12th in the IBM Office. To register, please email jkoblen@us.ibm.com

Optim Performance Manager Extended Edition for DB2® on Linux®, UNIX®, and Windows® is the latest offering from IBM to help you resolve emergent database performance problems before they affect the business. In this workshop, you will learn about the new capabilities provided in the product,including a powerful Web-based user interface with detailed diagnostic displays for problem analysis, out of the box reporting for both post mortem analysis and proactive trend analysis, enhanced integrations to support end-to-end diagnosis
and tuning, and expanded capabilities for deep performance insights into Java™
and DB2 call level interface applications.

Here is a link to a recent developer work's article which gives an introduction to the OPM solution.

http://www.ibm.com/developerworks/data/library/techarticle/dm-1004optimperformance/index.html