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

The DB2Night Show #208: 10 Minute Triage: Troubleshooting Db2 Performance

October 26, 2018, 3:40 pm
Posted by Scott in DB2 LUW
Michael Krafick, IBM Champion, Sr. DBA


Special Guest: Michael Krafick
IBM Champion
Senior DBA

10 Minute Triage: Troubleshooting Db2 LUW Production Issues

100% of our audience learned something!Per Michael's tweet this morning, "I will teach you how to say #holdmybeer while triaging #Db2 on production databases." Downtime is expensive. Most DBAs have been in the hot seat with management demanding rapid information and problem resolution. Michael shares his robust triage plan. Watch and learn from an experienced pro...

Show Host Scott Hayes Commentary

It wasn't that long ago that Michael won first place in our Db2's GOT TALENT worldwide contest. He is also a "Hall of Fame" speaker at IDUG. When you watch his presentation, you'll understand why. Michael makes great use of entertaining and helpful graphics, he's funny, he speaks from the heart and with solid knowledge and experience, and he shares ideas and tips that will help you be successful. 100% of our studio audience learned something, and there's a 100% chance that you will too! Don't miss a minute!

A message from our sponsor:
DBI Software

During today's quick commercial, DBI demonstrated some customer favorite features of DBI's Brother-Panther. We used a trend chart to find time periods when Index Read Efficiency (IREF) was high (Michael's favorite metric), then drilled down to the SQL that was running when IREF was high. From there, we demonstrated Explaining a costly statement, getting a solution, and Predictive Index Impact Analysis. #Awesome.

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 #208 in WMV format, right click on the link below and choose "Save As..."
Episode #208, 26 October 2018, 10 Minute Triage: Troubleshooting Db2 LUW Production Issues with Michael Krafick

MP4 Format - standard resolution - 156MB

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

NEW! Watch on YouTube!

PDF Handout!

Michael agreed to share a PDF of his presentation, so you can get your copy here: GET PDF!

Sharing is Caring!

Share a great show with your friends and followers!

Printer friendly