Run Visual Explain while running the query

For long running queries, you can choose to launch Visual Explain while the query is running. By refreshing the Visual Explain diagram, you can view the progress of the query.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Right-click the database that you want to work with and select Run SQL Scripts.
  4. If you have an existing SQL statement that you want to use, copy that statement and paste it into the Run SQL Scripts window.
  5. If you do not have an existing SQL statement, type a statement in the Run SQL Scripts window.
  6. Highlight the text of your statement and select Explain While Running from the Visual Explain menu.
  7. In the Visual Explain window, select Refresh from the Action menu or click the Refresh button to update the environment information.