Analyze an SQL plan cache snapshot data

To analyze the data in a snapshot of your SQL plan cache, do the following:

  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 snapshot folder.
  4. Right-click a snapshot and select Analyze.