Sybase recommends that you 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 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.
start_iq uses a default configuration file (%IQDIR15%/scripts/default.cfg) to set the start-up parameters to the defaults in Table 4-2.
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. |
For a complete list of startup parameters, see “The database server” in Chapter 2 of Sybase IQ Reference Manual.
If SQL Anywhere is installed on the same subnet as Sybase IQ,
the server must have a unique name. Both SQL Anywhere and Sybase IQ servers
default to the port 2638.
Use a new port number for each server. Set each new port number in the %IQDIR15%/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}
To override the default start-up parameters, store your options in a configuration file, and use this command to start your server:
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. .
The directory where the server is started becomes the default directory for all server files created by Sybase IQ.
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_iqdemo.0006.srvlog
If you have Sybase Central, you can use the Start Database Server wizard to start the database instead of start_iq. See Introduction to Sybase IQ for more information.
Always use the default colors of the Common Desktop
Environment when you run Sybase Central and dbisql.
Running these products under Open Windows or changing the default
colors may cause display problems.
