Viewing SQL statement summary data - Documentation for MainView for DB2 12.1
James Austin general
The SQL Summary view is displayed. This view displays important statistics for each SQL statement, including totals and averages across all executions. If the plan contains multiple DBRMs, the statements are sorted by package/DBRM (program).
BMC SOFTWARE -------------- SUMMARY TRACE ENTRY -----------PERFORMANCE MGMT
SERV ==> STRAC INPUT 12:09:36 INTVL=> 3 LOG=> N TGT==> JXODEEO
PARM ==> CB000001,SEQ=3,SQL,SORT=PGM ROW 1 OF 17 SCROLL=> CSR
EXPAND: MON(WKLD), DETAIL, CURRENT ACCOUNTING: ENV, ELAP, SQLCNTS, BPOOL, LOCKS, PRLL, PKG, RTN, ACC, DDF SUMMARIES: SQL, SCANS, IO/LOCK, SORTS
- - - - - - - - - - - - SQL SUMMARY (DETAIL TRACE ONLY) - - - - - - - - - - - STMT AVG. % AVG. % SORT PAGES SCANNED TYPE STMT COUNT ELAPSED ELAP CPU CPU RECS INDX DATA WORK+
------- ----- ----- -------- ----- -------- ----- ---- ---- ---- ----
PREPARE 190 16 4,370 us 1.4 817 us 19.9 0 250 42 0
DROP 289 1 4,199 ms 83.3 42 ms 64.1 0 574 41 0
CREATE 289 1 771 ms 15.3 9,555 us 14.6 0 100 35 0
INSERT 289 10 148 us 0.0 65 us 1.0 0 0 23 0
OPEN 264 1 169 us 0.0 161 us 0.2 10 0 3 0
FETCH 257 11 7 us 0.0 7 us 0.1 0 0 0 0
CLOSE 271 1 20 us 0.0 17 us 0.0 0 0 0 0
PGM:DSNESM68 41 100.0 100.0 10 924 144 0
** TOTALS *** 41 10 924 144 0