Abstract:

This presentation, originally written by IBM Distinguished Engineer John Campbell, provides guidance on using the DB2 Statistics Trace to focus on key areas such as data set activity, buffer pool and GBP performance, lock/latch contention, system address space CPU, EDM pool tuning, and DBM1 virtual and real storage management. It will help you identify the key performance indicators to be monitored and provide a number of useful rules-of-thumb which can be used to identify warning and danger conditions. It delves deeper to discuss investigating performance issues with more detailed tracing and analysis and provides tuning advice for common problems.

Mike Bracey is a DB2 for z/OS systems engineer based in the United Kingdom. He has been with IBM for over 26 years and has worked in various capacities as a DB2 branch specialist, DB2 consultant for designing, implementing and tuning applications, and DB2 beta programme manager for Europe. He has extensive practical DB2 experience, gained over 20 years, of DB2 application design, data modelling, and performance monitoring and tuning. He is currently a member of the IBM Software Business in Europe providing technical support for DB2 for z/OS, DB2 Tools and related topics. His current areas of interest are optimization, buffer pool tuning and XML.

	Close this Window
	Last Update: Sunday, 01 November 2009 @ 14:41
	(c) Copyright 2009 GSE UK Region