View Printable Version

DB2 LUW Problem Determination and Troubleshooting Workshop

Session Number: 1395
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Pavel Sustr [Software Engineer - IBM Toronto Lab]

Paradise Valley => Mon, May 12, 2014 (08:30 AM - 05:00 PM)

Speaker Bio: Pavel Sustr is a 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.

Anthony Reina is an Accelerated Value Specialist at the he IBM Canada Lab - Toronto Site. He works in the DB2 Software Group for the Accelerated Value Program (AVP) Team. He has worked with the DB2 Advance Support-FTS Team for more than 10 years, currently he works directly with IBM premium customers world wide in resolving defect related issues, developing solutions, and conducting education courses. His current focus is on the DB2 engine particularly Recovery and Optimizer areas.
Audience experience level: Intermediate, Advanced
Presentation Category: Disaster Recovery, Managing Availability, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), High Availability (DB2 for LUW)
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
Co-speaker Name: Anthony Reina

Abstract:  The popular DB2 LUW troubleshooting seminar, updated with 10 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