© Copyright IBM Corp. 2005, 2006. All rights reserved. 327
Chapter 6. Scenarios
In this chapter, we provide you with some examples of using PE to do database
or application performance trend analysis, identify performance problems with
various PE functions, and tuning databases and applications using PE.
The scenarios included in this chapter are:
Buffer pool utilization
Connection and workload management
Evaluating the effects of a configuration change
Identify and fix slow SQL statements
Responding to Performance Expert alerts
Transaction log full
Tuning DB2 for OLTP application with PE
6
Note: The scenarios in this chapter are all based on PE V2.1 FP1 or FP2,
since they were executed before PE V2.2 was available. But for our purposes,
the scenarios are still just as valid and have not been changed.

Get DB2 Performance Expert for Multiplatforms V2.2, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.