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
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.