Articles & Content
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.