Articles & Content
Topic: 2007 EU
Subtopic: DB2 for z/OS
DATE: 2007-11-7 (14:45 - 15:45)
SPEAKERS: Bryce Krohn (Krohn Enterprises, Inc.)
Monitoring a data sharing system can be a daunting, time consuming task. But there is a real need to keep track of how your data sharing system is performing. There are a lot of performance indicators to monitor and check. This presentation discusses the major mechanisms in data sharing global buffering and locking, and presents a list of some of the most important performance indicators for those DB2 mechanisms. Real world examples will be included to illustrate the importance of regularly monitoring a data sharing system. In addition, tips and tools that customers have used to help in the tracking of those indicators will be discussed. Where appropriate, these tips and tools will be made available to attendees
EXP. LEVEL: Intermediate,Advanced
Understand the mechanics of group buffer pools, and possible inhibitors. While this presentation does not allow time for a detailed explanation of group buffer pools, the major mechanisms will be covered.
Once the major mechanisms are understood, the DB2 support person needs to know how to monitor those mechanisms. The most important buffer performance indicators will be explained.
Understand the mechanics of global locking, as well as possible performance issues.
Know how to monitor the major performance indicators for global locking.
Understand the inter-relationships between the locking and buffering mechanisms of data sharing, and how a problem in one area can surface as a symptom in the other.
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.