Filter
Top Products
DB2 PM Statistics Report 215
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-11
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
BP2 GENERAL QUANTITY /MINUTE /THREAD /COMMIT BP2 READ OPERATIONS QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
CURRENT ACTIVE BUFFERS 97.50 N/A N/A N/A BPOOL HIT RATIO (%) 0.03
UNAVAIL.BUFFER-VPOOL FULL 0.00 0.00 N/C 0.00
GETPAGE REQUEST 5674.7K 167.2K N/C 2837.3K
NUMBER OF DATASET OPENS 0.00 0.00 N/C 0.00 GETPAGE REQUEST-SEQUENTIAL 5233.2K 154.2K N/C 2616.6K
GETPAGE REQUEST-RANDOM 441.4K 13.0K N/C 220.7K
BUFFERS ALLOCATED - VPOOL 50000.00 1473.36 N/C 25.0K
BUFFERS ALLOCATED - HPOOL 0.00 0.00 N/C 0.00 SYNCHRONOUS READS 9154.00 269.74 N/C 4577.00
HPOOL BUFFERS BACKED 0.00 0.00 N/C 0.00 SYNCHRON. READS-SEQUENTIAL 1435.00 42.29 N/C 717.50
SYNCHRON. READS-RANDOM 7719.00 227.46 N/C 3859.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 57.19
HPOOL EXPANS. OR CONTRACT. 0.00 0.00 N/C 0.00 SEQUENTIAL PREFETCH REQUEST 163.1K 4804.82 N/C 81.5K
VPOOL EXPANS. OR CONTRACT. 0.00 0.00 N/C 0.00 SEQUENTIAL PREFETCH READS 161.2K 4749.12 N/C 80.6K
VPOOL OR HPOOL EXP.FAILURE 0.00 0.00 N/C 0.00 PAGES READ VIA SEQ.PREFETCH 5155.8K 151.9K N/C 2577.9K
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 16958.00 499.71 N/C 8479.00
DYNAMIC PREFETCH READS 16389.00 482.94 N/C 8194.50
PAGES READ VIA DYN.PREFETCH 507.8K 15.0K N/C 253.9K
D.PRF.PAGES READ/D.PRF.READ 30.99
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 0.00 0.00 N/C 0.00