Viewing statements in a monitor

 

You can view SQL statements that are included in a detailed monitor.

Right-click any detailed monitor in the SQL performance monitor window and select Show statements.

The filtering options provide a way to focus in on a particular area of interest:

Minimum runtime for the longest execution

Filter to those queries with at least one long individual query instance runtime

Queries run after this date and time

Filters to those queries that have been run recently

Queries that use or reference these objects

Provides a way to limit the entries to those that referenced or use the table(s) or index(s) specified.

SQL statement contains

Provides a wildcard search capability on the SQL text itself. It is useful for finding particular types of queries. For example, queries with a FETCH FIRST clause can be found by specifying ‘fetch’. The search is case insensitive for ease of use. For example, the string 'FETCH' will find the same entries as the search string 'fetch'.

Multiple filter options can be specified. Note that in a multi-filter case, the candidate entries for each filter are computed independently and only those entries that are present in all the candidate lists are shown. So, for example, if you specified options Minimum runtime for the longest execution and Queries run after this date and time, you will be shown those entries with the minimum runtime that are run after the specified date and time.

 

Parent topic:

Using iSeries Navigator with detailed monitors

 

Related reference

Query optimizer index advisor