A15 - Solving DB2 Performance Problems

Session Number: 4260
Track: DB2 for z/OS - I
Session Type: Podium Presentation
Primary Presenter: Phil Grainger [BMC Software]
Time: May 04, 2017 (09:20 AM - 10:20 AM)
Room: South Ballroom

Speaker Bio: Phil has almost 30 years experience of DB2, from DB2 Version 1.2 to DB2 11

From a DBA for the largest user of DB2 at that time in the UK, through his time at PLATINUM technology and his Senior Principal Product Manager role for CA, Phil has always supported user groups. His work with IDUG includes being a past member of the European IDUG Planning Committee, an inductee into the IDUG Volunteer Hall of Fame and now IDUG Board Liaison for BMC Software

Phil has been honoured by IBM as an Information Champion from 2009 to 2016

Currently Phil is Lead Product Manager at BMC in support of their DB2 tools

Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), High Availability (DB2 for z/OS)
Objective 1: What is our objective in managing performance probems
Objective 2: How can we quickly triage performance problems
Objective 3: What data do we need to have to hand
Objective 4: What SHOULDN'T we be doing?
Objective 5: Wrap up and user experiences

Abstract:  This session looks at how you FIND performance problems, or more specifically, how you can eliminate DB2 problems from everyone elses. There is no need to spend exhaustive time looking for a DB2 problem only to find the solution lies somewhere else. So how can you QUICKLY (and easily) deflect attention when it is not warranted
We will also look at some techniques to make performance problem analysis easier – there are things you can do IN ADVANCE to help with fault finding
Lastly we will consider how to proof our DB2 subsystems and applications against performance problems in the future, and look at workload access path management