130 SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries
5.4.1 List Explainable Statements
The List Explainable Statements option from SQL Performance Monitor pane lists the SQL
statements for which a detailed SQL Performance Monitor has collected data and for which a
Visual Explain graph can be produced.
To access this function:
1. Click iSeries Navigator Database SQL Performance Monitors.
2. From the list of the SQL Performance Monitors that are currently on the system, right-click
a detailed collection and select List Explainable Statements, as shown in Figure 5-52.
Figure 5-52 Selecting the List Explainable Statements option
Chapter 5. Analyzing database performance data using iSeries Navigator 131
3. In the Explainable statements window (Figure 5-53), the upper half of the panel shows the
SQL statements that are monitored during the data collection session.
a. Click to select a statement that you are interested in analyzing. The selected statement
is then displayed in the lower half of the panel.
b. With the statement in focus, it is possible to have it analyzed and explained. Click the
Run Visual Explain button. For more information about “Visual Explain”, refer to
Chapter 8, “Analyzing database performance data with Visual Explain” on page 197.
c. With V5R3, since the columns in the upper half of the panel are sortable, you can
rearrange the data by clicking column head tab that you want to need to analyze. In our
example, we click the Time column to sort the columns by time sequence.
As you might have already noticed, the database analysis options and tools provided by
iSeries Navigator are well interconnected and meant to be used together in an iterative
manner.
Figure 5-53 Using List Explainable Statements
132 SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries

Get SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries now with O’Reilly online learning.

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