Filter
Top Products
© Copyright IBM Corp. 1999 119
Chapter 11. I/O Performance and Monitoring Tools
This chapter addresses I/O performance reporting 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. See Section
5ofthe
DB2 for OS/390 Administration Guide, 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 information online and in
batch.
The DB2 instrumentation data creates several types of trace records. The traces
relevant to I/O analysis are:
• Accounting Trace
•StatisticsTrace
• Performance Trace
Buffers
DB2
Applications
System
Cache
RMF
IXFP / RVA
DB2 PM
CPC
Paths
Storage Server
LPARs