Articles & Content

Archives

Case Studies in DB2 for z/OS Performance Tuning (Part 1 of 2) (B10)

Topic: DB2 for z/OS

Subtopic: 2007



DATE: 2007-5-9 (01:40 PM - 02:40 PM)
SPEAKERS: Lockwood Lyon (Fifth Third Bancorp)

What are the most important things that the beginning DB2 DBA needs toknow about performance tuning? What do you tune first: poorly-performing applications, SQL, bufferpools, indexes, what? If you can't afford tools, what information is available without them? What basic reports do I need to use in my job?

EXP. LEVEL: Beginner

OBJECTIVES:

Understand the different categories of performance tuningstrategy

Understand application-based tuning

Understand behavior-based tuning

Understand resource-based tuning

Understand how to read, understand, and interpret the threemost important performance reports



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.