Running SAP IQ Server

Use the startup utility, start_iq, to start your server. start_iq is a command line utility that runs on all platforms and ensures that all required parameters are set correctly.

Starting a Server or Database

To use start_iq to start a server or database, change to a directory where you have write privileges, and use the following command format:

start_iq [< server-options> ] [ <database-file >
[< database-options >]<, ...>]

<server-options> include the database server name and other options that control the behavior of the server, for all databases that are running on that server.
<database-file >is the file name of the catalog store. You can omit this option, or enter one or more database file names on the command line. Each of these databases is loaded and available for applications. If the starting directory contains the database file, you do not need to specify the path; otherwise, you must specify the path. You need not specify the .db file extension.
<database-options> are options that you can specify for each database file you start, that control certain aspects of its behavior.

Default Startup Parameters

start_iq uses a default configuration file ($IQDIR16/scripts/default.cfg ) to set the default start-up parameters.

Table 1: Parameters set by start_iq
Parameter	Value	Description
–c	48MB	Catalog store cache size.
–gc	20	Checkpoint interval.
–gd	all	Allows all users to start the database by connecting.
–gl	all	Allows all users to load or unload tables.
–gm	10	Default number of connections.
–gp	4096	Catalog store page size.
–ti	4400	Client timeout set to 72 hours. Prevents users with long queries from being logged off over a long weekend.

Note

If SAP SQL Anywhere is installed on the same subnet as SAP IQ, the server must have a unique name. Both SAP SQL Anywhere and SAP IQ servers default to the port 2638.

Use a new port number for each server. Set each new port number in the $IQDIR16/scripts/default.cfg file. Change the following line in each IQ database configuration file (for example, $IQDIR16/demo/iqdemo.cfg) to update the port number:

–x tcpip{port=2638}

Configuration Files

To override the default start-up parameters, store your options in a configuration file.

To start a server with a configuration file, use this syntax:

start_iq @<configuration_filename>.cfg <dbname>.db

This command starts the database and sets parameters named in the (optional) configuration (.cfg) file.

On the start_iq command line, the last option you specify takes precedence, so to override your configuration file, list any options you want to change after the configuration file name. For example:

start_iq @iqdemo.cfg –x 'tcpip{port=1870}' iqdemo.db

The –x parameter here overrides connection information in the iqdemo.cfg file.

A configuration file for the demo database (iqdemo.cfg) is installed in the $IQDIR16/demo directory as an example.

Default Server Directories

The directory where the server is started becomes the default directory for all server files created by SAP IQ.

Note If you run the start_iq utility from $IQDIR16/bin64, the script changes the directory to “./..” to avoid creating database files in the /bin directory.

Startup and Server Logs

SAP IQ writes start-up and server logs in the $IQDIR16/logfiles directory:

Startup information is saved in the servername.nnnn.stderr file.
Server status is logged in the servername.nnnn.srvlog file.

The <nnnn> variable in the file name indicates the number of times the server has been started. For example, localhost.0004.srvlog localhost_iqdemo.0006.srvlog.

Additional Information

Utility Guide > start_iq Database Server Startup Utility > start_iq Server Options