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 |
|
| ||||
| EDM POOL |
|
| QUANTITY | /MINUTE | /THREAD | /COMMIT | SUBSYSTEM SERVICES | QUANTITY | /MINUTE | /THREAD | /COMMIT | |
|
| ||||||||||||
| PAGES IN EDM POOL |
| 12500.00 | N/A | N/A | N/A | IDENTIFY |
| 0.00 | 0.00 | N/C | 0.00 | |
| % PAGES IN USE |
|
| 0.22 |
|
|
| CREATE THREAD |
| 0.00 | 0.00 | N/C | 0.00 |
| FREE PAGES IN FREE CHAIN |
| 12473.12 | N/A | N/A | N/A | SIGNON |
| 0.00 | 0.00 | N/C | 0.00 | |
| PAGES USED FOR CT |
| 0.88 | N/A | N/A | N/A | TERMINATE |
| 2.00 | 0.06 | N/C | 1.00 | |
| PAGES USED FOR DBD |
| 23.00 | N/A | N/A | N/A | ROLLBACK |
| 0.00 | 0.00 | N/C | 0.00 | |
| PAGES USED FOR SKCT |
| 3.00 | N/A | N/A | N/A |
|
|
|
|
|
| |
| PAGES USED FOR PT |
| 0.00 | N/A | N/A | N/A | COMMIT PHASE 1 |
| 0.00 | 0.00 | N/C | 0.00 | |
| PAGES USED FOR SKPT |
| 0.00 | N/A | N/A | N/A | COMMIT PHASE 2 |
| 0.00 | 0.00 | N/C | 0.00 | |
|
|
|
|
|
|
|
| READ ONLY COMMIT | 0.00 | 0.00 | N/C | 0.00 | |
| FAILS DUE TO POOL FULL |
| 0.00 | 0.00 | N/C | 0.00 |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| UNITS OF RECOVERY INDOUBT | 0.00 | 0.00 | N/C | 0.00 | |
| REQUESTS FOR CT SECTIONS |
| 0.00 | 0.00 | N/C | 0.00 | UNITS OF REC.INDBT RESOLVED | 0.00 | 0.00 | N/C | 0.00 | ||
| CT NOT IN EDM POOL |
| 0.00 | 0.00 | N/C | 0.00 |
|
|
|
|
|
| |
| CT REQUESTS/CT NOT IN EDM |
| N/C |
|
|
| SYNCHS(SINGLE PHASE COMMIT) | 2.00 | 0.06 | N/C | 1.00 | ||
| REQUESTS FOR PT SECTIONS |
| 0.00 | 0.00 | N/C | 0.00 | QUEUED AT CREATE THREAD | 0.00 | 0.00 | N/C | 0.00 | ||
| PT NOT IN EDM POOL |
| 0.00 | 0.00 | N/C | 0.00 | SUBSYSTEM ALLIED MEMORY EOT | 0.00 | 0.00 | N/C | 0.00 | ||
| PT REQUESTS/PT NOT IN EDM |
| N/C |
|
|
| SUBSYSTEM ALLIED MEMORY EOM | 0.00 | 0.00 | N/C | 0.00 | ||
| REQUESTS FOR DBD SECTIONS |
| 6.00 | 0.18 | N/C | 3.00 | SYSTEM EVENT CHECKPOINT | 0.00 | 0.00 | N/C | 0.00 | ||
| DBD NOT IN EDM POOL |
| 0.00 | 0.00 | N/C | 0.00 |
|
|
|
|
|
| |
| DBD REQUESTS/DBD NOT IN EDM | N/C |
|
|
|
|
|
|
|
|
| ||
| PREP_STMT_CACHE_INSERTS |
| 0.00 | 0.00 | N/C | 0.00 |
|
|
|
|
|
| |
| PREP_STMT_CACHE_REQUESTS |
| 0.00 | 0.00 | N/C | 0.00 |
|
|
|
|
|
| |
| PREP_STMT_CACHE_PAGES_USED |
| 0.00 | N/A | N/A | N/A |
|
|
|
|
|
| |
| PREP_STMT_HIT_RATIO |
| N/C |
|
|
|
|
|
|
|
|
|