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
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
Example:
CALL SYSPROC.AM_SAVE_TASK('M',11,'Task ABC',CAST (NULL AS CLOB(32K)),
'N','1,2,4,8,9,12')