Running SAP Sybase IQ Server

Starting a Server or Database

To use start_iq to start a server or database from the command line, change to a directory where the configuration and database files are located, 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.

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 SQL Anywhere is installed on the same subnet as SAP Sybase IQ, the server must have a unique name. Both SQL Anywhere and SAP Sybase 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, %ALLUSERSPROFILE%\SybaseIQ\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 %ALLUSERSPROFILE%\SybaseIQ\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 Sybase IQ.

Startup and Server Logs

SAP Sybase IQ writes start-up and server logs in the %ALLUSERSPROFILE%\SybaseIQ\logfiles directory:

Startup information is saved in the iq_startup_nt.log 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.srvloglocalhost_iqdemo.0006.srvlog

Additional Information

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