Db2 LUW Problem Determination and Troubleshooting Workshop

Pavel Sustr, IBM Corperation - Tuesday 29 May - Session 3

Pavel's troubleshooting seminar has scored very high reviews all over the world. Who can be a better teacher than somebody who works on the kernel code of Db2 itself. This seminar is (of course) completely up-to-date with all Db2 11 features and functions. Pavel shows all problem determination techniques with LIVE DEMOS! Learn how to identify and resolve database hangs, crashes, performance problems, and data corruption issues. Get familiar with diagnostic tools. Learn how and when to use these troubleshooting tools for a quick problem resolution.


  • Performance
  • FODC
  • Hangs
  • Latching
  • Crashes/Traps
  • Data Corruption

Attendees will be able to characterize a problem in order to expedite resolution, learn how and what data to collect during intermittent hangs, slowdowns, and other frequent problems, and understand Db2 Support’s methodology in troubleshooting Db2 and even non-Db2 hiccups. The seminar contains live demos during which the audience will be given an opportunity to perform an interactive investigation of selected problems.

Platform: LUW


← Back to all sessions

About: Pavel Sustr


Pavel is a Senior Manager and Senior Software Engineer with IBM Db2 development, responsible for multiple core Db2 kernel components. Always thrilled to work on hard to crack puzzles. Expertise in Db2 kernel architecture, configuration and administration, advanced problem determination, memory architecture, memory leak troubleshooting, and assembly language. Hands-on development experience with buffer pool management, storage, prefetching, page cleaning, transaction logging, recovery, monitoring, and problem determination. As a member of the Db2 team, Pavel spent years in Db2 L2/L3 advanced support (over 1,500 resolved cases), then transitioned to Db2 kernel development. In his past life Pavel was an application developer mostly using C++, SQL, .NET, Oracle, MS-SQL, and Informix on Windows, Linux, Solaris, and HP-UX.