Articles & Content


How to Monitor Your Data Sharing System, with Tips and Tools to Help! (Part 1 of 2) (B12)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-10 (09:20 AM - 10:20 AM)
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!

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.