Starting a Server from Interactive SQL

If you are already connected to a running database server, you can start a new server from Interactive SQL.

The following Interactive SQL command, entered on one line, starts a database server, names it jill_newserv, and specifies the network connection, number of connections, and catalog page size:

START ENGINE AS jill_newserv 
STARTLINE 'start_iq -x tcpip(port=5678) -gm 10 -gp 4096'

Use the START ENGINE command to start a named server from Interactive SQL.

This method is not recommended for most situations. If you use it, be sure you are starting the server on the system you intend, that you include appropriate server parameters in the command, and that environment variables are set appropriately on the system where the server will start.