start listen argument: Start a listen thread dynamically (SQL administration API)

Use the start listen argument with the admin() or task() function to 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  "start listen" , "server_name"
2  ) ;
Element Description Key Considerations
server_name The name of the database server for which you want to start a listen thread.

Usage

The definition of the listen thread must exist in the sqlhosts file for the server. If the definition of the listen thread does not exist in the sqlhosts file, you must add it before you can start the listen thread dynamically. For information on adding listen threads, see the HCL OneDB™ Administrator's Guide.

This function does not update the sqlhosts file.

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

Example

The following command starts a new listen thread for a server named ids_serv2:
EXECUTE FUNCTION task("start listen","ids_serv2");