A configuration file lists options that you want to set whenever you start your server. Installing Sybase IQ creates a configuration file called asiqdemo.cfg for the sample database. When you start the sample database, IQ runs this configuration file.
For example, for an asiqdemo database on a system named arches, the asiqdemo.cfg file might look like this:
-n arches_asiqdemo
-x tcpip{port=2638}
-c 32m
-gc 20
-gd all
-gl all
-gm 10
-gp 4096
-ti 4400
The asiqdemo.cfg file sets parameters that govern Sybase IQ to the following recommended defaults:
Parameter |
Value |
Description |
|---|---|---|
-n |
<HOSTNAME>_asiqdemo |
Name of system followed by “_asiqdemo” |
-c |
32MB on 32-bit systems, 48MB on 64-bit systems |
Catalog store cache size |
-gc |
20 minutes |
Checkpoint interval |
-gd |
all |
Users permitted to start a database |
-gl |
all |
Users permitted to load a table |
-gm |
10 |
Default number of connections |
-gp |
4096 |
Catalog store page size |
-ti |
4400 |
Client timeout |
-x |
tcpip{port=xxxx} |
Network connection protocol where xxxx=port number |
You can use the asiqdemo.cfg file as a template to create configuration files for all of your databases, if you make sure to:
Change the asiqdemo.cfg file name
Replace the –n value with a unique server name
Replace the –x port number with a unique port number for that server
When specifying network connections, you need a different server name:port# combination for each database server. When you connect to the server, you need to specify the same combination used to start the server.
If required parameters are not supplied in the start-up command, the asiqdemo.cfg file uses the parameter values from %ASDIR%\scripts\default.cfg. This file is also the source of parameters for the Service Manager, and for the params.cfg file used by Sybase Central and in multiplex configurations. You can maintain consistency by editing parameters in default.cfg.
It may be necessary to adjust parameters if virtual memory is inadequate. You can address this by reducing use by other programs, adding swap space to machines, or reducing IQ memory demand (cache sizes, thread count, and/or thread stack size).
To protect password information, you can encrypt your configuration files using the dbfhide (File Hiding) utility. For details see the Adaptive Server Anywhere Database Administration Guide. If you specify log file parameters (-o logfile) in encrypted files, the log is not available to the IQ Agent or start_asiq, which is unable to display server log information back to the database administrator. Sybase recommends that you put log file parameters and others that do not require encryption on the command line or in a separate configuration file. For example:
start_asiq @encrypt_params @other_params
or
start_asiq @encrypt_params -n myserv -c 400 -o $ASDIR/logfile/myserv.log
