View Printable Version

EDS7 - DB2 LUW Problem Determination and Troubleshooting Workshop

Session Number: 2459
Track: Ed. Sem
Session Type: Educational Seminar
Primary Presenter: Pavel Sustr [Software Engineer - IBM Toronto Lab]
Co-Presenter 1: Anthony Reina [Accelerated Value Specialist - IBM Canada Lab - Toronto Site]

Conestoga => Thu, May 07, 2015 (08:00 AM - 03:15 PM)

Speaker Bio: Software Engineer/Development Manager with DB2 LUW Development, responsible for Problem Determination, Monitoring, Security, and Buffer Pool services. Before IBM, he had held C++/SQL development positions using Informix, MS-SQL, and Oracle on HP-UX, Windows, and Solaris. With IBM, Pavel spent several years in DB2 UDB L2 Advanced Support (over 1,500 resolved cases), then moved on to DB2 Kernel Development. Expertise in DB2 LUW kernel architecture, configuration and administration, advanced problem determination, memory architecture/leak troubleshooting, and PowerPC/Intel/SPARC assembly language. Hands-on experience with the development of key kernel components, e.g. buffer pool management, storage, prefetching, page cleaning, transaction logging, and recovery.

Audience experience level: Intermediate, Advanced
Presentation Category: Data Management, Managing Availability
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Disaster Recovery (DB2 for LUW), High Availability (DB2 for LUW), SQL and XML Performance, User Experiences
Objective 1: Learn about documented and undocumented problem determination tools
Objective 2: Reveal the design internals of the First Occurrence Data Capture (FODC) feature
Objective 3: Get an insider view of problem determination techniques used by Support teams
Objective 4: Understand and analyze DB2 diagnostic data
Objective 5: Apply problem determination methodology and techniques, identify symptoms of common problems and effectively search knowledge base
Co-speaker Name: Anthony Reina
Co-speaker Bio: 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-DSD 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 Monitoring and Optimizer areas. He has also presented at IOD, IDUG, CASCON, and NA local DB2 User groups covering OPTIMIZER and Problem Determination/Management areas.

Abstract:  The popular troubleshooting seminar, updated with the newest problem determination techniques and LIVE DEMOS! Learn how to identify and resolve database hangs, locking problems, crashes, optimizer issues, and 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: database hang, abnormal termination, sub-optimal access plan, bad page, and slow performance.

For questions or concerns about your event registration, please contact