Deleting a plan for a statement

The database monitors the SQL plan cache size. When the size exceeds the maximum threshold, plans are discarded until the total size is within the threshold. You can delete a plan without waiting for the database to do it for you.

To delete a plan for a statement, 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 -> Show Statements.
  4. Enter filter information and click Apply. To just return all statements, click Refresh.
  5. Right-click a statement and select Plan -> Delete.