View SQL plan cache properties
To view the properties of your SQL plan cache, do the following:
- In the System i Navigator window, expand the system you want to use.
- Expand Databases and the database that you want to work with.
- 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.