IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

Managing DB2 Performance in a Heterogeneous Environment

Session Number: 2131
Track: General II (F)
Session Type: Podium Presentation
Primary Presenter: Jim Wankowski [Principal Consultant - CA Technologies]
Time: Nov 16, 2011 (09:45 AM - 10:45 AM)
Room: Leo

Speaker Bio: Jim Wankowski has more than 27 years of development and database administration experience with DB2 for both z/OS and LUW. Jim is currently a principal consultant with CA Technologies supporting their DB2 z/OS tools. Prior to joining CA Jim spent 10 years as the DB2 product manager for Quest Software and nine years as a DB2 product specialist at Platinum Technology. Jim is a well-known international speaker who has written articles for DB2 Magazine, and Z/Journal, and regularly presents at IDUG , regional DB2 user groups, and vendor seminars worldwide.
Audience experience level: Beginner, Intermediate
Presentation Category: Managing Performance
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Database Administrators, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS), New Release (DB2 for LUW), New Release (DB2 for z/OS)
Objective 1: How to define the performance goals for your particular environment
Objective 2: Understand the different monitoring facilities available with DB2 z/OS and LUW such as z/OS trace classes, LUW snapshot and event monitors
Objective 3: Learn the critical areas of both z/OS and LUW that need to be monitoring on a regular basis. What metrics to look at and what to look for to diagnose perfromance issues
Objective 4: Understand the different levels of automation available for DB2 LUW such as the Self Tuning Memory Manager, automatic space management, realtime statistics, and automatic reorg
Objective 5: Understand how the new autonomic runstats option works in DB2 for z/OS V10.

Abstract:  Many DBAs today have to manage DB2 running on multiple platforms. Proper monitoring and tuning of these environments is a complex time-consuming task. 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. The concept of autonomic or ‚Äúself-tuning‚Äù databases was originally introduced with DB2 LUW V8. Now with the release of DB2 for z/OS V10 autonomics are becoming available on z/OS as well. This presentation will compare the architectures of DB2 z/OS and LUW, and show you what to monitor and how to identify the most common areas of performance bottlenecks. It will then dive into the concept of autonomics and how this new automation can greatly reduce the tuning efforts required by DBA‚Äôs.

For questions or concerns about your event registration, please contact