Articles & Content

Archives

Fast Track To Optimal DB2 UDB Performance (B03)

Topic: 2005 NA

Subtopic: DB2 for z/OS



DATE: 2005-05-23 (02:00 PM - 03:10 PM)
SPEAKERS: Namik Hrle (IBM Boeblingen Lab)

Tuning DB2 UDB application 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: Beginner,Intermediate

OBJECTIVES:

DB2 UDB traces: source of key performance indicators

Where does problem transaction spend time?

CPU vs suspension time

Most common reasons for large suspension times

Tuning tips and hints



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.