Articles & Content


DB2 Performance and Tuning - Time Spent Breakdown

Topic: 2016 AU

Subtopic: Cross Platform DB2 for z/OS & LUW

It isn't easy to find performance bottlenecks and pinpoint the root causes from complex database systems with multiple applications and concurrent users. In this session, we'll go through a step-by-step, decision tree-based approach for tackling performance problems. We start by identifying the core area of the bottleneck - is it time spent processing, or time spent just waiting? Then, by using DB2's powerful monitoring interfaces, we refine our diagnosis, drilling down layer by layer. This logical, efficient approach not only helps us get to root cause, but it does so in a way that avoids wasting time by "trying random stuff" which isn't likely to help.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.