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. You can start the sample database using this configuration file as follows:
% cd $ASDIR/demo
% start_asiq @asiqdemo.cfg asiqdemo.db
For example, for an asiqdemo database on a system named arches on a 64-bit system, the asiqdemo.cfg file might look like this:
-n arches_asiqdemo
-c 48MB -gc 20
-gd all -gl all -gm 10 -gp 4096 -ti 4400 -x tcpip(port=5555)
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 in MB |
-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. Sybase strongly recommends that you change the default port number from 2638 to another number. |
You can use the asiqdemo.cfg file as a template to create configuration files for all of your databases if you:
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
If you use the same parameters to start all your databases, you could create a generic configuration file. Simply delete the –n and –x lines and supply these parameters on the command line at startup.
On
the start_asiq command line, the last
option specified takes precedence, so if you want to override your
configuration file, list any options you want to change after the
configuration file name. For example:
start_asiq @asiqdemo.cfg -n myserver
-x 'tcpip{port=1870}' asiqdemo
The –x parameter here overrides connection information in the asiqdemo.cfg file.
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.
You can add comments to configuration files by preceding each comment line with the #symbol. For example:
#These are the protocols: -x tcpip(port=3333)
The asiqdemo.cfg file gets default parameter values from $ASDIR/scripts/default/default.cfg. This file is also the source for the params.cfg file used in start_asiq, by Sybase Central, and in multiplex configurations. You can maintain consistency by editing parameters in default.cfg, although you should keep a copy and avoid changing recommended default values.
To protect password information, you can encrypt your configuration files using the dbfhide (File Hiding) utility. For details see 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 will be 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
