DROP CONTACT command using the ADMIN_CMD procedure

The DROP CONTACT command removes a contact from the list of contacts defined on the local system. A contact is a user to whom the Scheduler and Health Monitor send messages. 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 diagramDROP CONTACTname

Command parameters

CONTACT name
The name of the contact that will be dropped from the local system.

Example

Drop the contact named 'testuser' from the list of contacts on the server system. 
CALL SYSPROC.ADMIN_CMD( 'drop contact testuser' )

Usage notes

The DAS must have been created and be running.

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