The DB2Night Show #53: Achieving DB2 LUW Access Plan Stability

96% of our studio audience indicated they learned something! How awesome is that?!!? Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John shared with us more advice on how to optimize SQL queries, important ways to collect statistics, and how to "use a bigger hammer" to influence the DB2 optimizer. Learn about DB2 Optimization Profiles (DB2 "hints") and much more. Watch the replay and take advantage of all John's wisdom!!!

Host Commentary

I predict Episode #53 will be amongst the Top 10 most highly downloaded shows for 2011! If you only have time to watch a few episodes, make sure this one is on your short list! Yes, I know, I said the same thing about show #52. John Hornibrook is just simply that awesome!

Want slides? Keep reading...

Get the Download Replay

To download a recorded replay of Episode #53, right click on the link below and choose "Save As..."
Episode 53, 20 May 2011, Writing and Tuning Queries for Optimal Performance with John Hornibrook, IBM.

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format!

We asked our studio audience what other video formats they'd like to be able to download. MP4 for the Apple iPod, iPad, and iPhone was a very popular choice, so, as an experiment, we are also making this show available as an M4V file. Get it here: M4V (appx 84MB) . Please don't watch the replay while you are driving! icon_wink

Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

A message from today's show sponsor

Do you ever upgrade DB2? Apply fixpacks? Update your applications? Ever wonder about the performance consequences of these changes? What's better? What's worse? By how much?

During today's quick commercial break, DBI demonstrated how you can now easily compare database and SQL workload performance, for two different time windows, in as few as two mouse clicks!!! DBI's Brother-Panther® can vividly show you the performance differences between any two different time periods.

  • Is CPU utilization up or down?
  • Are transaction response times faster or slower?
  • Are SLAs being met more frequently or less?
  • Which SQL are running faster? Slower?
  • Which SQL are consuming more resources to run? Fewer resources?
If you seek answers to these questions, DBI has a solution! Don't settle for OEM "free" tools from your database vendor - this is part of a conspiracy to make sure you buy more hardware than you need! In fact, DBI offers a long list of competitive advantages: DB2 LUW Performance Tools Comparison

Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

References and Links

Just to give you a sample of some of the incredible content in this presentation (we don't usually do this), we are sharing 20 of 57 slides from John's slide deck via PDF: Download Sample Slides

REMEMBER to REGISTER for upcoming shows! www.DB2NightShow.com icon_cool