Articles & Content


Managing Performance in a Multi-Platform DB2 Environment (E12)

Topic: 2007 EU

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2007-11-7 (16:15 - 17:15)
SPEAKERS: Jim Wankowski (Quest Software)

Obtaining optimal performance from your DB2 applications is a multi-faceted exercise. DB2 performance optimization cannot be limited to simply tuning SQL. You need to have an understanding of how factors such as memory, physical design, and maintenance can affect performance. This presentation will compare architectures and show you how to identify and resolve the most common areas of performance bottlenecks in DB2 running on Linux, Unix, Windows, and z/OS. This presentation will compare/contrast the differences in memory architecture, physical design, maintenance, and SQL tuning techniques for applications running in z/OS vs. LUW.

EXP. LEVEL: Beginner,Intermediate


defining performance in your environment

Understand the different monitoring facilities which are available for z/Os and LUW and the basics of operation

Learn the key memory areas of these environments, how they can affect performance, what to monitor, and how to tune.

Understand the importance of a good physical design and how it can affect performance.

Understand the factors in application development which can affect performance and how to monitor/tune applications.

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.