Sample reports
This sample shows the report with one location expanded to the third level (SQL text).
File View Navigate Help
--------------------------------------------------------------------------------
F15: DB2 SQL CPU/Svc Time by Rq Loc (6783/CICS23A) Row 00001 of 01067
Command ===> __________________________________________________ Scroll ===> CSR
Nbr of --CPU Time-- --Svc Time--
Name Plan/Pgm Stmt# SQL Functn SQL Calls Total Mean Total Mean
CABNETDB24 295 1.66 0.00562 4.11 0.01394
- D00156 DDF2425A 279 FETCH 1 0.73 0.73480 0.79 0.79001
> Select count(*) from SYSIBM.SYSPACKSTMT
> (PREPARE of SQL was done at Stmt# 269 Seqno D00154)
- D00258 DDF2425A 279 FETCH 1 0.12 0.12491 0.14 0.14127
> Select count(*) from SYSIBM.SYSVLTREE
> (PREPARE of SQL was done at Stmt# 269 Seqno D00256)