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.
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 ], ...]
start_iq uses a default configuration file ($IQDIR16/scripts/default.cfg ) to set the default start-up parameters.
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. |
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}
To override the default start-up parameters, store your options in a configuration file.
start_iq @configuration_filename.cfg dbname.dbThis command starts the database and sets parameters named in the (optional) configuration (.cfg) file.
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.
The directory where the server is started becomes the default directory for all server files created by SAP Sybase IQ.
Startup information is saved in the servername.nnnn.stderr file.
Server status is logged in the servername.nnnn.srvlog file.