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


>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->
                     '-task--'      

>--"stop listen"--,--"server_name"--)--;-----------------------><

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");