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