Displaying the access path while monitoring an application or thread

Edit online

This topic shows how to view the access path while monitoring an application or thread.

To view the access path:
  1. Open the Thread Details window.
  2. In the folders pane, click SQL Statement.

    The SQL Statement pane shows the SQL statement that is currently run by the thread. The Explain button is enabled.

  3. Under SQL statement text, click Explain. If the statement contains a SELECT, UPDATE, INSERT, DELETE, or VALUES clause, Query Workload Tuner is opened to view the access path for this statement. Alternatively, if Administration Foundation is configured, a popup will be shown, returning Administration Foundation Tuning Job ID and clickable URL to Administration Foundation Tuning Job summary panel.
Note: Usually only one of the Explain products is started at the same time. (This depends on the data bridge server connection that is used.) You can also cut and paste the SQL statement text from IBM Z OMEGAMON AI for Db2 Java Client to manually create a project.