124 Storage Management with DB2 for OS/390
Table26. TraceRequirement for the I/O Activity Repor ts
Figure 47. BufferPool Section from I/O Activity Summar y Report
11.2 RMF Monitoring
From a DB2 point of view,I/O flows between disk storage and buffer pools. I/O
activity can be modeled as a three-step process involving pathing from hosts to
storage servers, caching of storage server,and internal activity between cache
and physical disk storage. Therefore,to monitor I/Oone must ask the following
questions:
• Which paths do I/Os use, and what is their workload?
• How efficient are the storage server cache algor ithms forthis workload?
• What is the performance, service time, and/or response time, offered by the
storage server?
I/O Activity Report DB2 Trace Class IFCID
Buffer Pool Performance 46, 7, 8, 9, 10, 105, 107
EDM Pool Performance 429, 30, 105, 107
Active Log Performance 534, 35, 36, 37, 38, 39
Archive Log/BSDS Performance 534, 35, 36, 37, 40, 41,
114, 115, 116, 119, 120
Cross Invalidation Performance 21 105, 107, 255
BUFFER POOL TOTALS AET
---------------------------- -------- ---------
TOTAL I/O REQUESTS 51 0.019885
TOTAL READ I/O REQUESTS 51 0.019885
NON-PREFETCH READS 51
PREFETCH READS
WITHOUT I/O 0
WITH I/O 0
PAGES READ 0
PAGES READ / SUCC READ 0.00
TOTAL WRITE REQUESTS 0
SYNCHRONOUS WRITES 0 N/C
COUPLING FACILITY CASTOUTS 0 N/C
PAGES WRITTEN PER WRITE 0.00
ASYNCHRONOUS WRITES 0 N/C
COUPLING FACILITY CASTOUTS 0 N/C
PAGES WRITTEN PER WRITE 0.00