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)
[ Top of Page | Previous Page | Next Page | Contents | Index ]