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

The DB2Night Show #160: Top 10 DB2 LUW Explain Tips with John Hornibrook

June 19, 2015, 5:10 pm
Posted by scott in DB2 LUW
John Hornibrook, STSM, IBM Canada

Special Guest: John Hornibrook, STSM, IBM Canada

Top 10 DB2 LUW Explain Tips

100% of our audience learned something! John Hornibrook is one of the top IBM brains behind DB2's optimizer. In this helpful presentation, John shares some invaluable tips for using and understanding DB2's Explain capabilities. You will learn the best ways to create Explain tables, upgrade them, and empty them, how to see actual cardinality values, how to determine if access plans have changed, and much more! Watch and learn...


Show Host Scott Hayes Commentary

Maybe you think you know about DB2's Explain capabilities, but a lot has been changed and improved in recent releases and fixpacks. Based on our audience's feedback, there's a 100% chance you will expand your knowledge of Explain by watching the replay of this show. Even I learned a few new cool things that I now want to experiment with!

During our show, the question came up "When was PLANID added?" John got back to me and indicated that PLANID, STMTID, and SEMANTIC_ENV_ID were added in 10.5 FP4. So, yes, as usual, it is worthwhile to make sure you are using current fixpack levels! To see a summary of the DB2 LUW 10.5 fixpack goodies (contents), John recommends THIS LINK.

More from John Hornibrook

Want to learn more from John? Check out these replays of past shows:


A message from our sponsor:
DBI Software

During today's quick 3 minute commercial, DBI demonstrated some performance trend charts that are complete with change indicators plotted on the charts. DBI has been automatically tracking important database change events since V8.2 of DB2. Change events are plotted on trend charts so that you can see the performance consequences of any changes. Trend charts without changes are, at best, merely pretty. Do you want pretty, or do you want results?

Magic Hat Money Working with DBI is like making money magically appear!

Typical customers enjoy 40-60% CPU utilization reductions in the first week, plus measurably faster transaction and query response times. More importantly, your time savings will be substantial! Read our newest SUCCESS STORY with HealthPlan Services, do your due diligence, and speak with as many references as you have time to call.

We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce performance on Black Friday multiple years in a row. 8 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? Contact DBI


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!

Get the Download Replays

WMV Format - approximately 65MB

To download a recorded replay of Episode #160 in WMV format, right click on the link below and choose "Save As..."
Episode #160, 19 June 2015, Top 10 DB2 LUW Explain Tips with John Hornibrook, STSM, IBM

MP4 Format - standard resolution - 112MB

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

PDF Handout

We can't do this will all of our guests, but John has graciously made a PDF of his presentation available. Now you can watch the replay and copy/paste John's SQL examples to give them a try! GET THE PDF.

Sharing is Caring!

Share a great show with your friends and followers!

Printer friendly