DB2 Version 9.7 for Linux, UNIX, and Windows

UPDATE HEALTH NOTIFICATION CONTACT LIST command using the ADMIN_CMD procedure

Updates the contact list for notification about health alerts issued by an instance.

Authorization

One of the following:
  • SYSADM
  • SYSCTRL
  • SYSMAINT

Required Connection

Database

Command Syntax

Read syntax diagramSkip visual syntax diagram
>>-UPDATE--+-HEALTH NOTIFICATION CONTACT-+--LIST---------------->
           '-NOTIFICATION----------------'         

   .-,---------------------------.   
   V                             |   
>----+-ADD--+--+-CONTACT-+--name-+-----------------------------><
     '-DROP-'  '-GROUP---'           

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.