Db2 LUW Forensic Investigation: Guide to Diagnosing Performance/Hang Problems

Session Number: 6116
Track: Hands on Labs
Session Type: Hands on Lab
Primary Presenter: Pavel Sustr [IBM Toronto Lab]
Time: Jun 03, 2019 (01:50 PM - 05:30 PM)
Room: Mecklenburg 2

Session Code: 6508
Speaker Bio: Senior Manager and Senior Software Engineer with IBM Db2 LUW development, responsible for multiple core Db2 kernel components. Always thrilled to work on hard-to-crack puzzles. Expertise in Db2 LUW 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 LUW 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.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Managing Availability, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), High Availability (DB2 for LUW)
Objective 1: Identify and collect the must-gather information for hangs or performance problems
Objective 2: Understand and analyze Db2 diagnostic data
Objective 3: Learn about documented and undocumented problem determination tools
Objective 4: Master shortcuts leading to problem resolution
Objective 5: Get an insider view of problem determination techniques used by Support teams

Abstract:  Learn how to efficiently analyze instance/database hangs and performance problems. Get a deep understanding of diagnostic logs, techniques, and advanced diagnostic tools shipped with the product. Explore the product's FODC capabilities. Learn how and when to use these troubleshooting tools for a quick problem resolution. The presentation contains a live demo during which the audience will be given an opportunity to perform an interactive investigation of real problems reported in the field.