This shows the report with one DBRM expanded to the second level (SQL statement):
File View Navigate Help -------------------------------------------------------------------------------- F07: SQL WAIT Time by DBRM (0611/CICS23A) Row 00001 of 00009 Command ===> __________________________________________________ Scroll ===> CSR Name Stmt# SQL Function Percent of Total Time * 10.00% ±2.5% *....1....2....3....4....5....6.....7. PFSAMPD 25.49 ============= -> S00001 435 FETCH 12.05 ======= -> S00003 541 UPDATE 7.50 === -> S00004 465 FETCH 3.95 == -> S00002 455 FETCH 1.91 = -> S00005 485 FETCH 0.06 -> S00008 462 OPEN 0.00 -> S00006 481 CLOSE 0.00 -> S00007 451 CLOSE 0.00
You can use the + command to expand an SQL statement and show the SQL text as shown here:
File View Navigate Help -------------------------------------------------------------------------------- F07: SQL WAIT Time by DBRM (0611/CICS23A) Row 00001 of 00009 Command ===> __________________________________________________ Scroll ===> CSR Name Stmt# SQL Function Percent of Total Time * 10.00% ±2.5% *....1....2....3....4....5....6.....7. PFSAMPD 25.49 ============= -> S00001 435 FETCH 12.05 ======= -> S00003 541 UPDATE 7.50 === -> S00004 465 FETCH 3.95 == -> S00002 455 FETCH 1.91 = > DECLARE RATE2 CURSOR FOR SELECT * FROM CUSTAMTS -> S00005 485 FETCH 0.06 -> S00008 462 OPEN 0.00 -> S00006 481 CLOSE 0.00 -> S00007 451 CLOSE 0.00
[ Top of Page | Previous Page | Next Page | Contents | Index ]