Articles & Content


Exploiting Query Monitor - How to Build a Performance Warehouse? (J06)

Topic: 2007 NA

Subtopic: DB2 for z/OS

DATE: 2007-5-8 (10:40 AM - 11:40 AM)
SPEAKERS: Thanikachalam 'Billy' Sundarrajan (Fifth Third Bank)

One of the significant challenges faced by most DBA teams is the ability to provide an effective data warehouse that will cater to the needs of the application programmers as well as the management team. The purpose of a performance data warehouse is usually multifold: from providing management with the ability to view things at a macro level, while providing the application team to drill down and track performance at a plan/package/SQL level.At Fifth Third, we used a combination of the Query Monitor data store, SMF101 data, and MXG processes to extract and store Plan, Package, and SQL level performance data.This presentation focusses on the challenges in designing an effective performance warehouse, and how we overcame the challenges.

EXP. LEVEL: Intermediate,Advanced


Performance data collection - Challenges

Designing Performance database - Plan, Package, SQL level tables - Summary and exception dataDesigning processes to extract useful performance data

Challenges in trending/accumulating performance data for static/dynamic SQL

Techniques for reducing performance monitoring overhead

Exception based monitoring - setting practical thresholds

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.