Filter
Top Products
110 Storage Management with DB2 for OS/390
Figure 34. DB2 PM Statistic Report Buffer Pool Reads
Figure 35. DB2 PM Statistic Report Buffer Pool Writes
BP4 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
BPOOL HIT RATIO (%) 55.12
GETPAGE REQUEST 221.8K 6534.43 N/C 110.9K
GETPAGE REQUEST-SEQUENTIAL 18427.00 542.99 N/C 9213.50
GETPAGE REQUEST-RANDOM 203.3K 5991.43 N/C 101.7K
SYNCHRONOUS READS 613.00 18.06 N/C 306.50
SYNCHRON. READS-SEQUENTIAL 64.00 1.89 N/C 32.00
SYNCHRON. READS-RANDOM 549.00 16.18 N/C 274.50
GETPAGE PER SYN.READ-RANDOM 370.36
SEQUENTIAL PREFETCH REQUEST 577.00 17.00 N/C 288.50
SEQUENTIAL PREFETCH READS 577.00 17.00 N/C 288.50
PAGES READ VIA SEQ.PREFETCH 18440.00 543.38 N/C 9220.00
S.PRF.PAGES READ/S.PRF.READ 31.96 K
LIST PREFETCH REQUESTS 0.00 0.00 N/C 0.00
LIST PREFETCH READS 0.00 0.00 N/C 0.00
PAGES READ VIA LIST PREFTCH 0.00 0.00 N/C 0.00
L.PRF.PAGES READ/L.PRF.READ N/C L
DYNAMIC PREFETCH REQUESTED 2515.00 74.11 N/C 1257.50
DYNAMIC PREFETCH READS 2515.00 74.11 N/C 1257.50
PAGES READ VIA DYN.PREFETCH 80470.00 2371.23 N/C 40.2K
D.PRF.PAGES READ/D.PRF.READ 32.00 M
BP1 WRITE OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
-------------------------- -------- ------- ------- -------
BUFFER UPDATES 15179.00 1517.84 410.24 0.67
PAGES WRITTEN 4608.00 0.00 N/C N/C
BUFF.UPDATES/PAGES WRITTEN J 3.29
SYNCHRONOUS WRITES G 0.00 0.00 N/C N/C
ASYNCHRONOUS WRITES H 187.00 18.70 5.05 0.01
PAGES WRITTEN PER WRITE I/O I 24.64
HORIZ.DEF.WRITE THRESHOLD 0.00 0.00 N/C N/C
VERTI.DEF.WRITE THRESHOLD 0.00 0.00 N/C N/C
DM CRITICAL THRESHOLD 0.00 0.00 N/C N/C
WRITE ENGINE NOT AVAILABLE 0.00 0.00 N/C N/C