Running multiplex servers

To start and stop IQ multiplex servers interactively, use Sybase Central or the start server utility, start_iq. To start IQ multiplex servers in scripts, you may use command line parameters.

The params.cfg file holds values for switches to control server startup features such as main and temp cache settings and error logging. Before you start the server, review and edit the params.cfg file located in the database directory for the server.

Table 1-1 in the Utility Guide describes startup switches. For more about params.cfg, see Table 2-1 in the System Administration Guide.

If you use Sybase Central to start the database:

1. Remove any -n switch in a params.cfg file used to start a multiplex database. Remove -x tcpip{port = } switch because Sybase Central prompts for the port number.

   The configuration file must not contain -n to name the server, or the database name or path.

2. The configuration file must be named params.cfg.

3. The configuration file must be located in the same folder or directory as the database file (.db).

Use Sybase Central to start multiplex servers interactively.

1. Log in using an account with DBA privileges and start Sybase Central as appropriate for your platform.

2. In the left pane of Sybase Central, select Sybase IQ 15.

3. Select Tools > Sybase IQ 15 > Start Server.

   By default, the wizard starts a single server. To start all servers, select the “All servers in multiplex” option button.

4. Follow the instructions in the wizard.

   When starting all of the servers in a multiplex, supply information for the coordinator. Always change the default port number for each server to a different number that is not in use.

The start_iq utility starts simplex or multiplex servers. The -n <engine name> switch is required. The engine name must match the server name used when creating the multiplex server. The -x (connection string) value must match tcpip connection parameters specified when creating the multiplex server. The database file path must match the database file path as specified when creating the multiplex server. For applications, the -gn value must be set higher than than total number of expected simultaneous requests plus 5 (for internal events and connections.) For a complete list of parameters, see the Utility Guide.

1. The following command starts a server and names it host1_test1_writer:

   start_iq @/host1/mpxdevices/params.cfg -n host1_test1_writer -x "tcpip{host=host1;port=2763}" /host1/mpxdevices/test1.db