restart listen argument: Stop and start a listen thread dynamically (SQL administration API)

Use the restart listen argument with the admin() or task() function to stop and then start 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--'      

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

Element Description Key Considerations
server_name The name of the database server for which you want to stop and restart a listen thread.  

Usage

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

If necessary, before you restart a listen thread, revise the sqlhosts entry. For example, if a running listen thread is bound to port 7777, you can change the port in the sqlhosts file, and then restart the thread.

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

This function does not update the sqlhosts file.

Example

The following command stops and then starts a listen thread for a server named ids_serv1:
EXECUTE FUNCTION task("restart listen","ids_serv1");

Copyright© 2019 HCL Technologies Limited