Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.