Articles & Content


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

Topic: 2007 NA

Subtopic: Cross Platform DB2 for z/OS & LUW

DATE: 2007-5-10 (09:20 AM - 10:20 AM)
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, proper maintenance, and SQL design can affect performance. If you are a DBA having to manage DB2 on multiple platforms, it is important that you have an understanding of the differences of what needs to be monitored. This presentation will discuss how to identify and resolve the most common areas of performance bottlenecks in DB2 running on Linux, Unix, Windows and z/OS. It 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


The first step in optimizing performance is to understand what is important to your business environment

In order to manage performance in a multi-platform environment the DBA needs to have a thorough understanding of the monitoring methods available in DB2 and when to use them

Proper memory allocation is the most critical facet of optimizing performance. This presentation will discuss the main aeas of memory across platforms, how to monitor them, and what sort of performance implications they may cause

Physical database design can have a direct impact on how an application will perform. This presentation discusses the different tablespace types and allocation methods and the pros/cons of each

Proper application design techniques are the most critical aspect of good performance. It is essential to have an understanding of the fundamentals of SQL design in order to code applications as efficiently as possible

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.