Verify SQL plan cache environment

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