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 sample 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 any 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
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.
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 sample database. For more information on startup options and configuration files, see the Sybase IQ documentation.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
