Supporting On Demand Business Applications with the IBM Problem Determination Tools (APA, DT, DT with Advanced Facilities, FA, File Export, FM, WS)

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.