The DB2Night Show #181: DB2 LUW Advanced Performance Diagnostics for SQL

David Kalmuk, STSM, IBM Canada
@DavidKalmuk

Special Guest: David Kalmuk, STSM, IBM Canada

DB2 LUW Advanced Performance Diagnostics for SQL

100% of our audience learned something! David gave us another great IDUG presentation packed with tips and advice for monitoring and diagnosing performance issues in DB2 LUW. A PDF handout is available so you can copy/paste from his SQL examples! Watch and learn...


Show Host Scott Hayes Commentary

In the IBM Canada Lab, David is responsible for the monitoring instrumentation of DB2 LUW, among other various responsibilities. I am very thankful he was willing to join us as our special guest. Pay attention to the replay - there's 100% chance you will learn something that will be helpful to you!


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 79MB

To download a recorded replay of Episode #181 in WMV format, right click on the link below and choose "Save As..."
Episode #181, 17 June 2016, DB2 LUW Advanced Performance Diagnostics for SQL with David Kalmuk

MP4 Format - standard resolution - 105MB

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 David has graciously made a PDF of his presentation available. Now you can watch the replay and copy/paste David's SQL examples to give them a try! GET THE PDF.

Sharing is Caring!

Share a great show with your friends and followers!

icon_wink