IDUG DB2 Tech Conference in Denver, Colorado, USA 2012
Denver Colorado Convention Center, Denver, Colorado
May 14-18, 2012

View Printable Version

DB2 LUW Problem Determination and Troubleshooting Workshop

Session Number: 147
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Pavel Sustr [IBM Toronto Lab]
Co-Presenter: Samir Kapoor [IBM]
Co-Presenter 2: Albert Grankin [IBM]

Room 112 => Mon, May 14, 2012 (08:30 AM - 05:30 PM)

Speaker Bio: Software Engineer with DB2 UDB kernel development. Before IBM, he had held C++/SQL development positions using Informix, MS-SQL, and Oracle on HP-UX, Windows, and Solaris. With IBM, he has spent several years in DB2 UDB L2 advanced support (over 1,500 resolved cases). Expertise in DB2 LUW kernel architecture, DB2 LUW configuration and administration, DB2 LUW advanced problem determination, DB2 LUW memory architecture/leak troubleshooting, and PowerPC/Intel/SPARC assembly language. Responsible for the development of DB2 kernel components for bufferpool management, storage, prefetching, page cleaning, transaction logging, and recovery.

Audience experience level: Intermediate, Advanced
Presentation Category: Disaster Recovery
Presentation Platform: Select a Value
Audiences this presentation will apply to: Database Administrators
Technical areas this presentation will apply to: Disaster Recovery (DB2 for LUW), Tools and Utilities
Objective 1: Apply problem determination methodology and techniques
Objective 2: Identify symptoms of common problems and effectively searching knowledge basis

Objective 3: Use problem determination techniques to gather diagnostic data

Objective 4: Analyze diagnostic data with problem determination tools

Objective 5: Communicate effectively with IBM support teams

Abstract:  The popular DB2 LUW troubleshooting seminar, updated with 9.7 techniques and LIVE DEMOS! Learn how to identify and resolve problems such as database hangs, locking problems, crashes and optimizer or performance problems. Get familiar with diagnostic tools. Learn how and when to use these troubleshooting tools for a quick problem resolution. Topics covered: Performance; Optimizer; FODC; Hangs; Locking/Latching; and Crashes/Traps. Attendees will be able to characterize a problem in order to expedite resolution, learn how and what data to collect during intermittent hangs, slow-downs, 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, e. g. database hang, slow performance, bad page, and DB2 instance abend.

For questions or concerns about your event registration, please contact