|
Special Guest: John Hornibrook, STSM, IBM Canada
Top 10 DB2 LUW Explain Tips100% 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:
- Episode #11, January 29, 2010 "DB2 9.7 Optimizer Updates"
- Episode #52, May 13, 2011 "Writing Optimized DB2 LUW SQL Queries"
- Episode #53, May 20, 2011 "Achieving DB2 LUW Access Plan Stability"
- Episode #57, September 9, 2011 "DB2 LUW Vital Statistics"
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?
|
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!Tweet