The easiest way to start Sybase IQ is with a configuration file. You can make a copy of the \Sybase\ASIQ-12_6\demo\asiqdemo.cfg configuration file that is created during IQ installation, rename it, and edit it for use with your RAP repository database. The default asiqdemo.cfg file sets these Sybase IQ 12.6 startup options:
-n <hostname>_asiqdemo -c 32m -gc 20 -gd all –gl all -gm 10 -gp 4096 -ti 4400 -x tcpip(port=2638)
Use a text editor to change the following values:
Set the -n parameter to the system and server of your sample IQ database. For example, if your hostname is RAP, set -n RAP_RAPIQ
-c 32m is for 32-bit platforms. Set -c 48m for 64-bit platforms.
Set -gm 40 for the number of connections.
Set the port to an available port number for that server, if port number 2638 is already in use. The default port number for IQ is 2638.
Include the host name, if you intend to start IQ from a remote server. For example,
-x tcpip(host=IQ_server;port=1234)
Add the following parameters:
-iqmc 256 -iqtc 128
The -iqmc parameter specifies 256 MB for IQ Main buffer cache and the -iqtc parameter specifies 128 MB for IQ Temp buffer cache. Increase the values of -iqmc and -iqtc, if more memory is available.
Rename the file, keeping the .cfg suffix, for example, RAP_RAPIQ.cfg
These should be the only changes required to use the configuration file with your RAP repository database. For more information on startup options and configuration files, see the Sybase IQ documentation.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
