Exit program to dump plan cache information for query
This Query Supervisor exit program dumps plan cache information about the query that reached a threshold.
The information is placed in a table named SUPERVISOR.PLAN_DUMPS. If the table does not exist, it will be created. If the table exists, the new plan cache snapshot will be appended to it. The SUPERVISOR schema must exist. See DUMP_PLAN_CACHE procedure for details.
Because SQL cannot be used directly in the exit program, the Run SQL (RUNSQL) CL command is submitted as a batch job.
