Filter
Top Products
DB2 PM Statistics Report 221
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-17
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
TOT4K GENERAL QUANTITY /MINUTE /THREAD /COMMIT TOT4K READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 106.55 N/A N/A N/A BPOOL HIT RATIO (%) 2.10
UNAVAIL.BUFFER-VPOOL FULL 0.00 0.00 N/C 0.00
GETPAGE REQUEST 5896.5K 173.8K N/C 2948.2K
NUMBER OF DATASET OPENS 0.00 0.00 N/C 0.00 GETPAGE REQUEST-SEQUENTIAL 5251.7K 154.8K N/C 2625.9K
GETPAGE REQUEST-RANDOM 644.8K 19.0K N/C 322.4K
BUFFERS ALLOCATED - VPOOL 151.0K 4449.56 N/C 75.5K
BUFFERS ALLOCATED - HPOOL 300.0K 8840.18 N/C 150.0K SYNCHRONOUS READS 9774.00 288.01 N/C 4887.00
HPOOL BUFFERS BACKED 51417.53 1515.13 N/C 25.7K SYNCHRON. READS-SEQUENTIAL 1499.00 44.17 N/C 749.50
SYNCHRON. READS-RANDOM 8275.00 243.84 N/C 4137.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 77.92
HPOOL EXPANS. OR CONTRACT. 0.00 0.00 N/C 0.00 SEQUENTIAL PREFETCH REQUEST 163.6K 4822.05 N/C 81.8K
VPOOL EXPANS. OR CONTRACT. 0.00 0.00 N/C 0.00 SEQUENTIAL PREFETCH READS 161.8K 4766.36 N/C 80.9K
VPOOL OR HPOOL EXP.FAILURE 0.00 0.00 N/C 0.00 PAGES READ VIA SEQ.PREFETCH 5174.3K 152.5K N/C 2587.2K
S.PRF.PAGES READ/S.PRF.READ 31.99
CONCUR.PREF.I/O STREAMS-HWM 5.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 1.00 0.03 N/C 0.50 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 19473.00 573.82 N/C 9736.50
DYNAMIC PREFETCH READS 18904.00 557.05 N/C 9452.00
PAGES READ VIA DYN.PREFETCH 588.3K 17.3K N/C 294.2K
D.PRF.PAGES READ/D.PRF.READ 31.12
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 128.00 3.77 N/C 64.00