©Copyright IBM Corp. 1999 119
Chapter 11. I/O Performanceand Monitoring Tools
Thischapter addresses I/Operformance repor ting and monitoring tools in relation
to storage management in a DB2 environment. The following tools are described:
• DB2 Performance Monitor (DB2 PM)
• Resource Monitoring Facility (RMF)
• IBM Extended Facilities Product (IXFP) for RVA monitoring
Figure 42 on page 119 illustrates the scope of these tools.
Figure 42. Scope of Performance Analysis Tools

11.1 DB2 PM Overview

DB2 generates data about its own performance, called instrumentation data, but
it has no reporting facility to analyze this data. The entries in the DB2 installation
panel DSNTIPN, reported in Figure 43 on page 120, activate audit, global,
accounting , and monitoring traces as well as checkpoint frequency.S ee Section
5oftheDB2 for OS/390 AdministrationGuide, SC26-8957, for more information
on the trace categories.
DB2 PM provides the capability to gather, analyze, and report on DB2
instrumentation data. DB2 PM can report performance informationonline and in
batch.
The DB2 instrumentation data creates several types of trace records. The traces
relevantto I/O analysis are:
• Accounting Trace
•StatisticsTrace
• Performance Trace

Buffers

DB2

Applications

System
Cache
RMF
IXFP / RVA
DB2PM
CPC
Paths
Storage Server
LPARs