Sample reports
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.002You 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