stop listen argument: Stop a listen thread dynamically (SQL administration API)

Use the stop listen argument with the admin() or task() function to stop an existing listen thread for a SOCTCP or TLITCP network protocol without interrupting existing connections.

Syntax


1  EXECUTE FUNCTION
1 admin
1 task
2  (
2  "stop listen" , "server_name"
2  ) ;
Element Description Key Considerations
server_name The name of the database server for which you want to stop a listen thread.

Usage

The definition of the listen thread must exist in the sqlhosts file.

This function does not update the sqlhosts file.

This function is equivalent to the onmode -P stop server_name command.

Example

The following command stops a listen thread for a server named ids_serv3:
EXECUTE FUNCTION task("stop listen","ids_serv3");