Articles & Content

Archives

Fast Track to Optimal DB2 Performance (B01)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-5-19 (09:45 AM - 10:45 AM)
SPEAKERS: Namik Hrle (IBM Boeblingen Lab)

Tuning DB2 applications to achieve optimal DB2 performance does not need to be a complex exercise. A large majority of problems can be easily solved and the only challenge is connecting the problem symptom with its underlying causes. This presentation offers you a simple methodology to answer the challenge. Numerous ready-to-use hints and tips are included to maximize the presentation's practical value.

EXP. LEVEL: Intermediate

OBJECTIVES:

Understand DB2 traces as the source of key performance indicators.

Review time distribution: where does problem transaction spend time?

Understand CPU vs suspension time.

Learn most common reasons for large suspension times.

Get tuning tips and hints based on interpreting DB2 timers.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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