View Printable Version

DB2 LUW Problem Determination and Troubleshooting Workshop

Session Number: 4050
Track: DB2 for LUW
Session Type: Podium Presentation
Primary Presenter: Anthony Reina [Accelerated Value Specialist - IBM Canada Lab - Toronto Site]
Tue, Sep 15, 2015 (09:30 AM - 05:00 PM)

Speaker Bio: Anthony Reina is an Accelerated Value Specialist with the DB2 Software Group for the Accelerated Value Program (AVP) Team at the IBM Canada Lab - Toronto Site. Prior to this he was with the the DB2 Advance Support-DSD Team, 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 PD/PSI, BLU, and Optimizer areas.
Audience experience level: Beginner, Intermediate
Presentation Category: Data Management
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW)
Co-speaker Name: Pavel Sustr

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