END_PLAN_CACHE_EVENT_MONITOR procedure

The END_PLAN_CACHE_EVENT_MONITOR procedure ends the event monitor identified by the given monitor-ID.

Authorization: The caller must have *JOBCTL special authority or be authorized to the QIBM_DB_SQLADM function usage ID.

Read syntax diagramSkip visual syntax diagramEND_PLAN_CACHE_EVENT_MONITOR( monitor-ID)
The schema is QSYS2.
monitor-ID
A character or graphic string expression that identifies the monitor to be ended.

Example

  • End the plan cache monitor identified by PLANCACHE1.
    CALL QSYS2.END_PLAN_CACHE_EVENT_MONITOR('PLANC00001');