When the report is first displayed, only the first level of the hierarchy is visible (Thread). A sample is shown here:
File View Navigate Help -------------------------------------------------------------------------------- F02: DB2 SQL Activity Timeline (1264/CICS23A) Row 00001 of 01596 Command ===> __________________________________________________ Scroll ===> CSR Thread REQCT Program Stmt# SQL Function Samps Call Time Interval CPU Time 52577 08557 PFSAMPA 816 SELECT 1 08:24:45.96 0.00 0.002 52577 08564 PFSAMPA 816 SELECT 1 08:24:46.25 0.00 0.001 52577 08566 PFSAMPB 678 SELECT 1 08:24:46.27 0.00 0.002 52577 08567 PFSAMPC 1316 SELECT 2 08:24:46.27 0.01 0.001 52577 08569 PFSAMPC 1443 OPEN 1 08:24:46.28 0.00 0.002 52577 08570 PFSAMPC 1466 FETCH 2 08:24:46.29 0.01 0.003 52577 08571 PFSAMPC 1466 FETCH 2 08:24:46.30 0.01 0.002 52577 08586 PFSAMPC 3155 SELECT 3 08:24:46.32 0.01 0.006 52577 08587 PFSAMPC 3179 SELECT 1 08:24:46.33 0.00 0.005 52577 08588 PFSAMPB 816 UPDATE 1 08:24:46.34 0.00 0.002 52577 08592 PFSAMPA 816 SELECT 1 08:24:46.50 0.00 0.001 52577 08598 PFSAMPA 816 SELECT 1 08:24:46.68 0.00 0.001 52577 08599 PFSAMPB 408 SET HOST VAR 1 08:24:46.69 0.00 0.002 52577 08601 PFSAMPC 1316 SELECT 5 08:24:46.69 0.03 0.003 52577 08604 PFSAMPC 1466 FETCH 1 08:24:46.73 0.00 0.001 52577 08605 PFSAMPC 1466 FETCH 3 08:24:46.74 0.01 0.001 52577 08607 PFSAMPC 2989 SELECT 1 08:24:46.76 0.00 0.002
You can enter a "+" line command to expand to the next level, which is the SQL text. The report is shown here where a thread has been expanded:
File View Navigate Help -------------------------------------------------------------------------------- F02: DB2 SQL Activity Timeline (1264/CICS23A) Row 00001 of 01599 Command ===> __________________________________________________ Scroll ===> CSR Thread REQCT Program Stmt# SQL Function Samps Call Time Interval CPU Time 52577 08557 PFSAMPA 816 SELECT 1 08:24:45.96 0.00 0.002 52577 08564 PFSAMPA 816 SELECT 1 08:24:46.25 0.00 0.001 52577 08566 PFSAMPB 678 SELECT 1 08:24:46.27 0.00 0.002 52577 08567 PFSAMPC 1316 SELECT 2 08:24:46.27 0.01 0.001 52577 08569 PFSAMPC 1443 OPEN 1 08:24:46.28 0.00 0.002 52577 08570 PFSAMPC 1466 FETCH 2 08:24:46.29 0.01 0.003 52577 08571 PFSAMPC 1466 FETCH 2 08:24:46.30 0.01 0.002 52577 08586 PFSAMPC 3155 SELECT 3 08:24:46.32 0.01 0.006 > SELECT * INTO : H , : H , : H , : H , : H : H FROM > DEPT WHERE XRATE = : H 52577 08587 PFSAMPC 3179 SELECT 1 08:24:46.33 0.00 0.005 52577 08588 PFSAMPB 816 UPDATE 1 08:24:46.34 0.00 0.002 52577 08592 PFSAMPA 816 SELECT 1 08:24:46.50 0.00 0.001 52577 08598 PFSAMPA 816 SELECT 1 08:24:46.68 0.00 0.001 52577 08599 PFSAMPB 408 SET HOST VAR 1 08:24:46.69 0.00 0.002 52577 08601 PFSAMPC 1316 SELECT 5 08:24:46.69 0.03 0.003
[ Top of Page | Previous Page | Next Page | Contents | Index ]