298 Supporting On Demand Business Applications with the IBM Problem Determination Tools
SQL CPU Time Accumulated CPU time used by the statement for the duration of the
measurement (DB2+ must be active).
Service Time Accumulated service time used by the statement for the duration of
the measurement (DB2+ must be active).
12.3.7 F07 - DB2 SQL WAIT Time by DBRM
F07 shows information about WAIT time that occurred during the processing of SQL
requests. We expand each module line to see a further breakdown and quantification by
individual SQL statement, as shown in Figure 12-74.
Figure 12-74 F07: SQL WAIT Time by DBRM (expanded)
This helps to answer these questions about SQL processing wait time:
򐂰 For how much of the overall measurement interval was the address space in a WAIT
during SQL processing?
򐂰 For how much of the SQL processing time was the address space in a WAIT?
Note: If the source program mapping feature was not available, “SQL Source statement in”
information will not be displayed.
Note: The SETUP command line lets us choose to see the WAIT time expressed as a
percentage of SQL service time for the DBRM or as a percentage of the total
measurement interval.
Chapter 12. Application Performance Analyzer: analyzing a job with subsystem 299
Because source program mapping data is available, by entering the P line command on any
sequence number, Application Performance Analyzer displays the source code for the
statement (as shown in Figure 12-75) for the sequence number S0007.
Figure 12-75 P01: Source Program Attribution (from F07)
Note: The Count value is the number of samples taken of execution of the SQL statement
while in WAIT.
This applies to DB2 reports F07, F08, and F09.
Note: The SETUP line command has been used to show detailed information in the
heading. This information includes:
򐂰 Load module name
򐂰 Load library name
򐂰 CSECT name
򐂰 Source mapping file name
򐂰 Compile date and time
򐂰 Code segment address range (when applicable)
It is usually preferable to turn off this option, as it occupies several lines at the top of the
screen.

Get Supporting On Demand Business Applications with the IBM Problem Determination Tools (APA, DT, DT with Advanced Facilities, FA, File Export, FM, WS) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.