View SQL plan cache properties

To view the properties 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. Right-click SQL plan cache snapshot and select SQL Plan Cache -> Properties.

You may be able to edit your plan cache properties by right-clicking a property and selecting Edit Value.