212 Storage Management with DB2 for OS/390
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-8
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
CPU TIMES TCB TIME SRB TIME TOTAL TIME /THREAD /COMMIT
------------------------------- --------------- --------------- --------------- --------------- ---------------
SYSTEM SERVICES ADDRESS SPACE 2.416151 0.344193 2.760344 N/C 1.380172
DATABASE SERVICES ADDRESS SPACE 0.018771 1:10:30.043799 1:10:30.062569 N/C 35:15.031285
IRLM 0.000490 0.958605 0.959095 N/C 0.479547
DDF ADDRESS SPACE 0.000000 0.000117 0.000117 N/C 0.000059
TOTAL 2.435412 1:10:31.346714 1:10:33.782125 N/C 35:16.891063
NON-CPU TIME N/A N/A 0.000000 N/C 0.000000
DB2 APPL.PROGR.INTERFACE QUANTITY /MINUTE /THREAD /COMMIT DATA CAPTURE QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
ABENDS 0.00 0.00 N/C 0.00 LOG RECORDS CAPTURED 0.00 0.00 N/C 0.00
UNRECOGNIZED 0.00 0.00 N/C 0.00 LOG READS PERFORMED 0.00 0.00 N/C 0.00
COMMAND REQUESTS 0.00 0.00 N/C 0.00 LOG RECORDS RETURNED 0.00 0.00 N/C 0.00
READA REQUESTS 0.00 0.00 N/C 0.00 DATA ROWS RETURNED 0.00 0.00 N/C 0.00
READS REQUESTS 0.00 0.00 N/C 0.00 DESCRIBES PERFORMED 0.00 0.00 N/C 0.00
WRITE REQUESTS 0.00 0.00 N/C 0.00 DATA DESCRIPTIONS RETURNED 0.00 0.00 N/C 0.00
TABLES RETURNED 0.00 0.00 N/C 0.00
TOTAL 0.00 0.00 N/C 0.00
OPTIMIZATION QUANTITY /MINUTE /THREAD /COMMIT IFC DEST. WRITTEN NOT WRTN BUF.OVER NOT ACCP WRT.FAIL
--------------------------- -------- ------- ------- ------- --------- -------- -------- -------- -------- --------
PREP_STMT_MATCH 0.00 0.00 N/C 0.00 SMF 36.00 0.00 0.00 0.00 0.00
PREP_STMT_NO_MATCH 0.00 0.00 N/C 0.00 GTF 0.00 0.00 N/A 0.00 0.00
IMPLICIT_PREPARES 0.00 0.00 N/C 0.00 OP1 0.00 0.00 N/A 0.00 N/A
PREP_FROM_CACHE 0.00 0.00 N/C 0.00 OP2 0.00 0.00 N/A 0.00 N/A
CACHE_LIMIT_EXCEED 0.00 0.00 N/C 0.00 OP3 0.00 0.00 N/A 0.00 N/A
PREP_STMT_PURGED 0.00 0.00 N/C 0.00 OP4 0.00 0.00 N/A 0.00 N/A
OP5 0.00 0.00 N/A 0.00 N/A
OP6 0.00 0.00 N/A 0.00 N/A
OP7 0.00 0.00 N/A 0.00 N/A
OP8 0.00 0.00 N/A 0.00 N/A
RES 0.00 N/A N/A N/A N/A
TOTAL 36.00 0.00 0.00 0.00
IFC RECORD COUNTS WRITTEN NOT WRTN LATCH CNT QUANTITY QUANTITY QUANTITY QUANTITY MISCELLANEOUS
----------------- -------- -------- --------- -------- -------- -------- -------- --------------------
SYSTEM RELATED 7.00 7.00 LC01-LC04 0.00 0.00 0.00 0.00 BYPASS COL: 0.00
DATABASE RELATED 7.00 7.00 LC05-LC08 0.00 0.00 0.00 0.00
ACCOUNTING 6.00 0.00 LC09-LC12 0.00 0.00 0.00 0.00
START TRACE 1.00 0.00 LC13-LC16 0.00 5.00 0.00 0.00
STOP TRACE 1.00 0.00 LC17-LC20 0.00 0.00 0.00 0.00
SYSTEM PARAMETERS 0.00 0.00 LC21-LC24 0.00 0.00 1.00 3110.00
SYS.PARMS-BPOOLS 7.00 7.00 LC25-LC28 0.00 0.00 0.00 0.00
AUDIT 0.00 0.00 LC29-LC32 0.00 0.00 0.00 0.00
TOTAL 29.00 21.00