DB2 10.5 for Linux, UNIX, and Windows

AM_DROP_TASK procedure - Delete a monitoring task

The AM_DROP_TASK procedure deletes a monitoring task. It does not return any data.

Syntax

Important: The related activity monitor routines have been deprecated in Version 10.1 and might be removed in a future release. For more information, see Activity monitor routines have been deprecated.


>>-AM_DROP_TASK--(--task_id--)---------------------------------><

The schema is SYSPROC.

Procedure parameter

task_id: An input argument of type INTEGER that specifies a unique monitoring task ID.

Authorization

One of the following authorities is required to execute the routine:

EXECUTE privilege on the routine
DATAACCESS authority
DBADM authority
SQLADM authority

Default PUBLIC privilege

In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the procedure is automatically created.

Example

Drop the monitoring task with ID 5.

CALL SYSPROC.AM_DROP_TASK(5)