Filter
Top Products
DB2 PM Statistics Report 217
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-13
GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM: 02/12/99 15:06:03.00
MEMBER: NB22 TO: 02/12/99 15:44:05.00
SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64
DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80
---- HIGHLIGHTS ----------------------------------------------------------------------------------------------------
INTERVAL START : 02/12/99 15:09:49.64 SAMPLING START: 02/12/99 15:09:49.64 TOTAL THREADS : 0.00
INTERVAL END : 02/12/99 15:43:45.80 SAMPLING END : 02/12/99 15:43:45.80 TOTAL COMMITS : 2.00
INTERVAL ELAPSED: 33:56.157107 OUTAGE ELAPSED: 0.000000 DATA SHARING MEMBER: N/A
BP4 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP4 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 1.77 N/A N/A N/A BPOOL HIT RATIO (%) 55.12
UNAVAIL.BUFFER-VPOOL FULL 0.00 0.00 N/C 0.00
GETPAGE REQUEST 221.8K 6534.43 N/C 110.9K
NUMBER OF DATASET OPENS 0.00 0.00 N/C 0.00 GETPAGE REQUEST-SEQUENTIAL 18427.00 542.99 N/C 9213.50
GETPAGE REQUEST-RANDOM 203.3K 5991.43 N/C 101.7K
BUFFERS ALLOCATED - VPOOL 50000.00 1473.36 N/C 25.0K
BUFFERS ALLOCATED - HPOOL 100.0K 2946.73 N/C 50.0K SYNCHRONOUS READS 613.00 18.06 N/C 306.50
HPOOL BUFFERS BACKED 51417.53 1515.13 N/C 25.7K SYNCHRON. READS-SEQUENTIAL 64.00 1.89 N/C 32.00
SYNCHRON. READS-RANDOM 549.00 16.18 N/C 274.50
DFHSM MIGRATED DATASET 0.00 0.00 N/C 0.00
DFHSM RECALL TIMEOUTS 0.00 0.00 N/C 0.00 GETPAGE PER SYN.READ-RANDOM 370.36
HPOOL EXPANS. OR CONTRACT. 0.00 0.00 N/C 0.00 SEQUENTIAL PREFETCH REQUEST 577.00 17.00 N/C 288.50
VPOOL EXPANS. OR CONTRACT. 0.00 0.00 N/C 0.00 SEQUENTIAL PREFETCH READS 577.00 17.00 N/C 288.50
VPOOL OR HPOOL EXP.FAILURE 0.00 0.00 N/C 0.00 PAGES READ VIA SEQ.PREFETCH 18440.00 543.38 N/C 9220.00
S.PRF.PAGES READ/S.PRF.READ 31.96
CONCUR.PREF.I/O STREAMS-HWM 0.00 N/A N/A N/A
PREF.I/O STREAMS REDUCTION 0.00 0.00 N/C 0.00 LIST PREFETCH REQUESTS 0.00 0.00 N/C 0.00
PARALLEL QUERY REQUESTS 0.00 0.00 N/C 0.00 LIST PREFETCH READS 0.00 0.00 N/C 0.00
PARALL.QUERY REQ.REDUCTION 0.00 0.00 N/C 0.00 PAGES READ VIA LIST PREFTCH 0.00 0.00 N/C 0.00
PREF.QUANT.REDUCED TO 1/2 0.00 0.00 N/C 0.00 L.PRF.PAGES READ/L.PRF.READ N/C
PREF.QUANT.REDUCED TO 1/4 0.00 0.00 N/C 0.00
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
PREF.DISABLED-NO BUFFER 0.00 0.00 N/C 0.00
PREF.DISABLED-NO READ ENG 0.00 0.00 N/C 0.00
SYNC.HPOOL READ 0.00 0.00 N/C 0.00
ASYNC.HPOOL READ 0.00 0.00 N/C 0.00
HPOOL READ FAILED 0.00 0.00 N/C 0.00
ASYN.DA.MOVER HPOOL READ-S 0.00 0.00 N/C 0.00
ASYN.DA.MOVER HPOOL READ-F 0.00 0.00 N/C 0.00
PAGE-INS REQUIRED FOR READ 59.00 1.74 N/C 29.50