REMOVE_PC_EVENT_MONITOR procedure

The REMOVE_PC_EVENT_MONITOR procedure deletes a file containing an event monitor.

Authorization: The caller must have:
  • *USE authority to the library, and
  • *OBJOPR and *OBJEXIST authorities to the event monitor file.
Read syntax diagramSkip visual syntax diagramREMOVE_PC_EVENT_MONITOR(PLAN_CACHE_LIBRARY => library-name,PLAN_CACHE_FILE => file-name)
The schema is QSYS2.
library-name
A character or graphic string expression that identifies the name of the library containing file-name.
file-name
A character or graphic string expression that identifies the name of an existing event monitor file.

Example

  • Remove the plan cache event monitor PRUNEDP1 in SNAPSHOTS.
    CALL QSYS2.REMOVE_PC_EVENT_MONITOR('SNAPSHOTS','PRUNEDP1');