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