AM_SAVE_TASK procedure - Create or modify a monitoring task

The AM_SAVE_TASK procedure creates or modifies a monitoring task.

Syntax

>>-AM_SAVE_TASK--(--mode--,--task_id--,--task_name--,----------->

>--appl_filter--,--show_lock_chains--,--report_ids--)----------><

The schema is SYSPROC.

Procedure parameters

mode

An input argument of type CHAR(1) that specifies whether to create a new monitoring task ('C') or to modify an existing monitoring task ('M').

task_id

An input argument of type INTEGER that specifies a unique monitoring task ID. When mode is 'C', any specified input for task_id is ignored. An ID for the new monitoring task will be generated by the procedure and returned in the output. When mode is 'M', specifies the ID of the monitoring task that is being modified.

task_name

An input argument of type VARCHAR(128) that specifies a name or short description for a monitoring task.

appl_filter

An input argument of type CLOB(32K) that specifies an application filter. An application filter is a search condition involving any or all of the three columns AGENT_ID, APPL_NAME, and AUTH_ID, where AGENT_ID and AUTH_ID are integers, and APPL_NAME is a character string. If the argument is null or an empty string, no filtering is performed.

show_lock_chains

An input argument of type CHAR(1) that specifies whether lock chains are to be shown. Valid values are 'Y' and 'N'. If the argument is null, lock chains are not to be shown.

report_ids

An input argument of type VARCHAR(3893) that specifies one or more report IDs separated by commas.

Authorization

EXECUTE privilege on the AM_SAVE_TASK procedure.

Example

CALL SYSPROC.AM_SAVE_TASK('M',11,'Task ABC',CAST (NULL AS CLOB(32K)),
   'N','1,2,4,8,9,12')