title="David Kalmuk on LinkedIn"> @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?

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 title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">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? target="NEW" title="Let's have a conversation - Contact DBI">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! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">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!


Tweet

Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=692