Plan Cache Analyzer provides the ability to collect and analyze snapshots of the system's SQL plan cache. It is designed to complement the features already available in IBM i Navigator (found in IBM i Access for Windows) for analyzing the plan cache by providing several graphs and drill-down options not available there. The plan cache is a repository that contains the access plans for queries that were optimized by SQE. This component is included with the Job Watcher service.

For more information that describes the plan cache and query engine on IBM i, visit the IBM Knowledge Center.