SQL plan cache event monitor

You can access the SQL plan cache event monitor through the System i® Navigator interface or by calling the procedures directly.

The SQL plan cache event monitor captures monitor records of plans as they are removed from the plan cache. The event monitor is useful for ensuring that all performance information potentially available in the cache is captured even if plans are removed from the cache. Combining the event monitor output with a plan cache snapshot provides a composite view of the cache from when the event monitor was started until the snapshot is taken.

The event monitor allows the same filtering options as described for Show statements and NewSnapshot. The exceptions are that the Top 'n' most frequently run statements and the Top 'n' statements with largest total accumulated runtime are not shown. Once a statement is removed from the cache, it is no longer compared to other plans. Therefore, these two 'Top n' filters do not make sense for pruned plans.