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


1  EXECUTE FUNCTION
1 admin
1 task
2  (
2  "restart listen" , "server_name"
2  ) ;
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");