Conor O'Mahony's Database Diary

Your source of IBM database software news (DB2, Informix, Hadoop, & more)

Archive for September 2010

Winning Entry in the “Do You DB2?” Contest

with one comment

The Independent DB2 User Group (IDUG) recently ran a contest called Do You DB2? where DB2 users were encouraged to share their experiences. I’d like to congratulate Michael Krafick of Atlanta, GA who won the Grand Prize of a 55″ internet-ready HDTV for describing his organization’s experiences with IBM Smarter Systems. Here are some excerpts from his story:

…a database with multiple partitions over three nodes. Initially performing well, we soon discovered that predicted monthly growth for the database was grossly underestimated. Performance and trending were showing that we were going to run into a problem sooner rather than later.

Not to mention, this was a data mart supporting Business Intelligence in a financial market. We were heading into that special time of year where the planets align – where month end loads, quarter end loads, and year end loads were about to collide.

… This is where IBM’s Balanced Warehouse methodology comes in to save the day… We would extend our cluster out by one more BCU to give us some more horsepower… The result was incredible. Here is just a taste of what we saw:

  • Our CPU utilization saw a 50% drop. Where we had consistently ran at 95% utilized (spiking to 100%) we dropped to an average of 45% utilized.
  • We were able to increase our workload by 10% compared to the month before (2077 Report Views over 1935 Report Views).
  • Even with the additional increase in workload, we decreased our execution time by 50% (Original Execution Time- 357 Hours, New Execution Time – 210 Hours).

Essentially, our reports were flying and the client immediately came back “raving” over our speed. Our hard work had paid off and the DBA’s released a huge sigh of relief. There is a real feeling of accomplishment when you win one for the team.

Congratulations Michael!


Written by Conor O'Mahony

September 8, 2010 at 5:22 pm

%d bloggers like this: