Run Visual Explain from SQL plan cache snapshot information

You can run Visual Explain using the information captured in a SQl plan cache snapshot.

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases and the database that you want to work with.
  3. Click SQL Plan Cache Snapshots.
  4. Right-click the snapshot that you want to use and select Show Statements.
  5. Apply filtering information (if any) and click Refresh.
  6. Select the SQL statement you want to visually explain.
  7. Click Visual Explain and the SQL statement is displayed, as a graph, in the Visual Explain window.