I was recently contacted by a DBA at a large insurance company. After upgrading from DB2 V8.2 to 9.1.0.3, the DBA activated the Self Tuning Memory Manager (STMM) in the hope that it would solve all performance woes. To the contrary, performance got worse, and the DBA noted a marked increase in SORT overflows. He even opened a PMR with IBM. But this isn't a case of STMM gone crazy; something else is going on, but what? Let's take a look at the numbers and discover the truth.

[ more.. ]

Congratulations to the IDUG Europe Conference Planning Committee (CPC)! IDUG Europe 2008 was one of the best IDUG conferences ever! On 17 October 2008, I taught the one day Ed Seminar "DB2 LUW Performance Diagnosis Learning Lab." This post contains a review of one of the participant's data and findings. The data comes from a busy production database that runs a banking application.

[ more.. ]