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
Figure 5-53 Using List Explainable Statements