UPDATE HEALTH NOTIFICATION CONTACT LIST command using the ADMIN_CMD procedure
The UPDATE HEALTH NOTIFICATION CONTACT LIST command updates the contact list for notification about health alerts issued by an instance.
Authorization
One of the following authorities:
- SYSADM
- SYSCTRL
- SYSMAINT
Required Connection
Database
Command Syntax
Command Parameters
- ADD GROUP name
- Add a new contact group that will notified of the health of the instance.
- ADD CONTACT name
- Add a new contact that will notified of the health of the instance.
- DROP GROUP name
- Removes the contact group from the list of contacts that will notified of the health of the instance.
- DROP CONTACT name
- Removes the contact from the list of contacts that will notified of the health of the instance.
Example
Add the contact group 'gname1' to the health notification contact list:
CALL SYSPROC.ADMIN_CMD( 'update notification list add group gname1' )Usage note
Command execution status is returned in the SQLCA resulting from the CALL statement.