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 |
|
| |||||
| 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 |
|
|
| ||
|
| 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 | 5251.7K | 154.8K | N/C | 2625.9K | ||
|
|
|
|
|
|
|
| GETPAGE | 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. | 1499.00 | 44.17 | N/C | 749.50 | ||
|
|
|
|
|
|
|
| SYNCHRON. | 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 | 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 | 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 |
|
|
| |
|
|
|
|
|
|
|
| 0.00 | 0.00 | N/C | 0.00 | ||
|
|
|
|
|
|
|
| 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 | |
|
|
|
|
|
|
|
| 128.00 | 3.77 | N/C | 64.00 | ||
Page 243
Image 243
