Articles & Content

Archives

Fast Track to Optimal DB2 Performance (B01)

Topic: DB2 for z/OS

Subtopic: 2008



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.



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.