Verify SQL plan cache environment
To verify your SQL plan cache environment, 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 and select Verify. Your SQL plan cache information
is now verified and the information that you see is updated.