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

Read syntax diagramSkip visual syntax diagram
>>-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");

Copyright© 2019 HCL Technologies Limited