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

The DB2Night Show #211: Db2 LUW Favourite Problem Determination Tricks

January 25, 2019, 3:19 pm
Posted by nightshow in DB2 LUW
Pavel Sustr, Sr. Mgr, IBM Canada


Special Guest: Pavel Sustr
Sr. Manager
IBM Canada Lab

Db2 LUW Favourite Problem Determination Tricks!

100% of our HUGE audience learned something! #MindBlown The secrets to analyzing Db2 problems are out! Pavel gave us a fantastic introduction to his top problem determination tricks and techniques! You will learn about db2pd, DB2SLEEP, db2fodc, db2dart, db2pdcfg, db2trc, db2diag, analyzetrace, analyzestack, and more! Command examples and sample outputs are provided! Watch and learn...

Show Host Scott Hayes Commentary

Pavel's introduction to Db2 LUW problem determination was fantastic! Don't just download the PDF, make sure you watch the replay too so that you can get Pavel's explanations and elaborations! And, the best news is, this show was just a teaser for more to come! 21 June will be our last show of our 10th season, and Pavel will give a THREE HOUR in-depth class on Db2 Problem Determination! Save the date on your calendars now! June 21, 2019, 10am-1pm CDT/11am-2pm EDT, Reserved for Db2 PD with Pavel!

We are now publishing The Db2Night Show Replays to our YouTube Channel. Please subscribe!

A Request from Pavel - Please Help!

The Db2 IBM Canada Lab would appreciate your participation in a survey being conducted by Stack Overflow. Please Take The Survey!

A message from our sponsor:
DBI Software

DBI's next webinar "SEE and FIX What You Are MISSING! Db2 LUW Monitoring and Tuning Made Easy!" is offered on 22 February at 1pm CST/2pm EST. Please visit DBI Events for details and registration.

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!

Have you registered to attend IDUG yet?

Attend IDUG in Charlotte NC June 2-6

Get the Download Replays

WMV Format - approximately 136MB

To download a recorded replay of Episode #211 in WMV format, right click on the link below and choose "Save As..."
Episode #211, 25 January 2019, Db2 LUW Favourite Problem Determination Tricks!

MP4 Format - standard resolution - 172MB

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

NEW! Watch on YouTube!

PDF Handout

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

Sharing is Caring!

Share a great show with your friends and followers!

Printer friendly