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.


Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(------------------------------->

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


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.


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

Copyright© 2018 HCL Technologies Limited