1 | LOCATION: USIBMT6BOAPLX |
|
| DB2 PERFORMANCE MONITOR (V5) |
|
|
| PAGE: |
|
| |||
| 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 | ||||
|
|
|
|
|
|
|
|
|
| ||||
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 |
|
|
| ||||
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 | 18427.00 | 542.99 | N/C | 9213.50 | ||||
|
|
|
|
|
|
| GETPAGE | 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. | 64.00 | 1.89 | N/C | 32.00 | ||||
|
|
|
|
|
|
| SYNCHRON. | 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 | 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 | 0.00 | N/A | N/A | N/A |
PREF.I/O STREAMS REDUCTION | 0.00 | 0.00 | N/C | 0.00 |
PARALLEL QUERY REQUESTS | 0.00 | 0.00 | N/C | 0.00 |
PARALL.QUERY REQ.REDUCTION | 0.00 | 0.00 | N/C | 0.00 |
PREF.QUANT.REDUCED TO 1/2 | 0.00 | 0.00 | N/C | 0.00 |
PREF.QUANT.REDUCED TO 1/4 | 0.00 | 0.00 | N/C | 0.00 |
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 |
|
|
|
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 |
|
|
| |
BUFFER | 0.00 | 0.00 | N/C | 0.00 | |
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 | 0.00 | 0.00 | N/C | 0.00 | |
ASYN.DA.MOVER HPOOL | 0.00 | 0.00 | N/C | 0.00 | |
59.00 | 1.74 | N/C | 29.50 |