DB2 Version 10.1 for Linux, UNIX, and Windows

UPDATE CONTACTGROUP command using the ADMIN_CMD procedure

Updates the attributes of a contact group that is defined on the local system. A contact group is a list of users who should be notified by the Scheduler and the Health Monitor.

The setting of the Database Administration Server (DAS) contact_host configuration parameter determines whether the list is local or global.

Authorization

None

Required Connection

Database. The DAS must be running.

Command Syntax

Read syntax diagramSkip visual syntax diagram
>>-UPDATE CONTACTGROUP--name------------------------------------>

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

>--+------------------------------+----------------------------><
   '-DESCRIPTION--new description-'   

Command Parameters

CONTACTGROUP name
Name of the contact group which will be updated.
ADD CONTACT name
Specifies the name of the new contact to be added to the group. A contact can be defined with the ADD CONTACT command after it has been added to a group.
DROP CONTACT name
Specifies the name of a contact in the group that will be dropped from the group.
ADD GROUP name
Specifies the name of the new contact group to be added to the group.
DROP GROUP name
Specifies the name of a contact group that will be dropped from the group.
DESCRIPTION new description
Optional. A new textual description for the contact group.

Example

Add the contact named 'cname2' to the contact group named 'gname1':
CALL SYSPROC.ADMIN_CMD( 'update contactgroup gname1 add contact cname2' )

Usage notes

The DAS must have been created and be running.

Command execution status is returned in the SQLCA resulting from the CALL statement.