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


Posted by Scott on October 26, 2018, 3:40 pm
in DB2 LUW ( The DB2Night Show)







title="Michael Krafick on LinkedIn">
Michael Krafick, IBM Champion, Sr. DBA



@MKrafick


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...








title="Michael Krafick on LinkedIn">
Michael Krafick, IBM Champion, Sr. DBA



@MKrafick


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 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 #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!
















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