Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show Episode #11: DB2 9.7 Optimizer Updates

January 29, 2010, 7:07 pm
Posted by Scott in DB2 LUW
In our eleventh show, special guest John Hornibrook, Manager, Query Optimization Development DB2 for Linux, UNIX, & Windows, IBM Canada shared with us details of enhancements to the DB2 Optimizer in DB2 9.7 GA and Fixpack 1. The list of enhancements is very impressive! Watch this show to learn more...

To download a recorded replay of Episode #11, right click on the link below and choose "Save As..."
Episode 11, 2010 Jan 29, DB2 9.7 Optimizer Updates with John Hornibrook (54MB)

Thanks for watching!

A Shameless Marketing Moment

During this episode, DBI's short two minute sponsorship commercial included a brief live demonstration of DBI's performance analysis, tuning, and trending tools for DB2 LUW. Here's what we did:

  • Click 1: Database Triage - identify the database having the worst performance problems
  • Click 2: Response Time analysis showed us that the database was CPU bound
  • Click 3: We isolated the SQL statements that were causing the database to be CPU bound
  • Click 4: We Explained the SQL statement having the highest aggregate CPU cost and determined that a high quality index was needed
  • Click 5: We passed the high CPU cost statement to the IBM Design Advisor and received validation - a second opinion if you will - that the index we thought was needed was indeed needed, and that the proposed index would provide a tremendous CPU cost reduction.
THAT'S IT - JUST FIVE MOUSE CLICKS to identify, isolate, and resolve a performance problem! We could have done it in just three clicks but didn't want to show off! icon_biggrin

While you're here and waiting for your download to complete, why not spend a minute checking out DBI's performance management tools for IBM DB2 LUW? Visit our Products page to get started!

A typical DBI customer reduces CPU utilization by 30-90% and improves response times within just a few hours of DBI tools installation! DBI helps worldwide customers achieve remarkable breakthrough results overnight with a ripple effect of measurable bottom line benefits and rapid ROI.

Your host,
Scott Hayes

Printer friendly