CaseStudy 147
Figure 66. DB2 PM Accounting Buffer Pool Summary

12.1.4 Conclusions

This example shows a very complexand heavy read-only query. Five-way
parallelism has been used to reduce elapsed time.
The query is CPU bound with complex stage 2 type predicates, which access
many pages but producea small result set of 100 rows.
Sequential prefetch, dynamicpr efetch,and sequential reads are executed. I/O
response time is excellent.
The query could probably benefit from a higher degree of parallelism or from a
fastercentral processor.
Summary of I/O operations
Sequential prefetch requests: 164649
Dynamic prefetch requests: 26065
Totalprefetch requests: 190714
Totalsynchronous reads: 19559
TotalI/O requests: 210273
AverageI/O per second: 93
12.2 Storage Server Analysis
From the storageser veranalysis point of view, the first activity, in such a case
study,is to eliminate unnecessary data from large RMF and IXFP reports. After
the data has been discarded,you apply the methodology described in Chapter
11.2, “RMF Monitoring” on page 124, and Chapter 11.3, “IXFP Monitoring” on
page 135 to access the relevant information.

12.2.1 RM F Views

RMF generates a report set for each LPAR.In each set, the cache subsystem
activity report displays the same common view overall sharing LPARs at the LCU
level.Therefore, the process of extracting data to analyze is mainly based on
TOT4K TOTAL
--------------------- --------
BPOOL HIT RATIO (%) 2 E
GETPAGES 6135875
BUFFER UPDATES 48
SYNCHRONOUS WRITE 0
SYNCHRONOUS READ 19559 F
SEQ. PREFETCH REQS 164649 G
LIST PREFETCH REQS 0 H
DYN. PREFETCH REQS 26065 I
PAGES READ ASYNCHR. 5943947 J
HPOOL WRITES 0
HPOOL WRITES-FAILED 0
PAGES READ ASYN-HPOOL 0
HPOOL READS 0
HPOOL READS-FAILED 0