Articles & Content

Archives

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

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2007



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

OBJECTIVES:

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.



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.