View Printable Version

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

Session Number: 5106
Track: Db2 for LUW - I
Session Type: Educational Seminar
Primary Presenter: Pavel Sustr [IBM Toronto Lab]
Time: Apr 30, 2018 (03:20 PM - 04:20 PM)
Room: Commonwealth A

Session Code: C03
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: Data Management, Disaster Recovery, Managing Availability, Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Data Architects, Database Administrators, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), User Experiences
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.

For questions or concerns about your event registration, please contact