IBM 5655-DB2 Server User Manual


 
DB2 PM Statistics Report 207
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-3
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
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