IDUG DB2 Tech Conference in Sydney, Australia 2014
Sydney, Australia
10 - 12 September, 2014

View Printable Version

DB2 LUW Problem Determination and Troubleshooting Workshop

Session Number: 3053
Track: LUW & Cross Platform
Session Type: Podium Presentation
Primary Presenter: Anthony Reina [Accelerated Value Specialist - IBM Canada Lab - Toronto Site]
Room(s)/
Time(s):

1.16 => Fri, Sep 12, 2014 (08:30 AM - 03:45 PM)

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-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: Beginner, Intermediate, Advanced
Presentation Category: Data Management
Presentation Platform: DB2 for Linux, UNIX, Windows
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users
Technical areas this presentation will apply to: Disaster Recovery (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: Analyse diagnostic data with problem determination tools
Objective 5: Communicate effectively with IBM support teams

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 aucpc@idug.org