Run start_iq at the command line to customize your server startup.
Use server startup switches with the start_iq command to configure SAP Sybase IQ multiplex servers at startup.
| Startup Switch | Values | Description |
|---|---|---|
| -iqgovern num | integer | Sets the number of concurrent queries allowed by the server. The number of concurrent queries is not the same as the number of connections. A single connection can have multiple open cursors. |
| -iqmpx_failover | 1 | Initiates multiplex coordinator failover to establish the designated failover secondary node as the new coordinator. Starting the coordinator with this option has no effect. |
| -iqmpx_ov | 1 | Performs multiplex configuration override for the current node. Used to change node properties during startup in the event that a node's location or other property has changed. |
| -iqmpx_sn | 1 | Runs the current multiplex node in single-node mode. Use single-node mode only to fix problems with the multiplex configuration. You must shut down all other nodes in the multiplex. Use single-node mode only on the coordinator. |
| -iqmpx_reclaimwriterfreelist | server name | This option applies only while restarting a coordinator node. The coordinator forcefully reclaims the free list of the writer node identified by the server name. Use this switch only when a writer fails and cannot be restarted. |
| -iqmsgnum num | 0-64 (inclusive) | Specifies the number of message log archives of the
old message log maintained by the server. Default
value is 0, which means that messages are wrapped
in the main message log file. Takes effect only if
-iqmsgsz or the
IQMsgMaxSize
server property is nonzero. The IQMsgNumFiles server
property corresponds to -iqmsgnum and takes
precedence over the value of -iqmsgnum. If the value
is not set, the default minimum pool size is:MIN (MAX (4, number of cores/4) , mipcmaxt (if set)). |
| -iqmsgsz size | integers 0-2047 inclusive, in MB. | Limits the maximum size of the message log. The default value is 0, which specifies no limit on the size of the message file. |
| -mipcmint size | integers 0-256 inclusive | Specifies the minimum number of threads allowed in the shared
thread pool for MIPC request handling. Each new
MIPC server connection adds two threads to the
pool. The value of -mipcmint defaults to 0 and cannot
exceed the -mipcmaxt value. Set this value only if
advised to do so by Sybase Technical Support. If
the value is not set, the default minimum pool
size is: MIN (MAX (4, number of cores/4), mipcmaxt (if set)) |
| -mipcmaxt size | integers 0-256 inclusive | Specifies the maximum number of threads allowed in the shared
thread pool for MIPC request handling. Each new
MIPC server connection adds two threads to the
pool. The value of -mipcmaxt defaults to 0 and must exceed
the -mipcmint
value. Set this value only if advised to do so by
Technical Support. If the value is not set, the
default maximum pool size is: MAX (number of cores, mipcmint) |