The DB2Night Show #52: Writing Optimized DB2 LUW SQL Queries

Brilliant! Very Helpful! Outstanding! Participants in the studio audience of Episode #52 gave this show EXCEPTIONAL ratings! Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John offered a buffet of outstanding advice on how to get your SQL to run faster and more efficiently! And, John should know the secrets - he IS the mastermind behind the DB2 LUW Optimizer! Watch the replay and take advantage of all John's advice!!!

Host Commentary

I predict Episode #52 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!

Get the Download Replay

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

We asked our studio audience what other video formats they'd like to be able to download. MP4 for the Apple iPod 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 89MB) . Please don't watch the replay while you are driving! icon_wink

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

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 11 of 59 slides from John's slide deck via PDF: Download Sample Slides

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