Now you are ready to test your installation. This section tells how to start and stop the server.
To start the server, change to a directory where you have write privileges and run the start_asiq utility, using the following command format:
start_asiq @configuration_filename.cfg dbname.db
This command starts the database and sets parameters named in the (optional) configuration (.cfg) file.
If Adaptive Server Anywhere is installed on the same
subnet as Sybase IQ, you must change the default port number for
IQ; both products use the default port of 2638. First, set a new
port number in the $ASDIR\scripts\default.cfg file.
Then update each IQ database configuration file (for example, ASDIR\demo\asiqdemo.cfg)
by changing the port number in the following line:
-x tcpip{port=2638}
Change to an unused number, for example, 4444:
-x tcpip{port=4444}
You can use a configuration file to specify options that you want to set whenever you start your server. A configuration file for the sample database is installed in the $ASDIR/demo directory as an example. For details about configuration files, see “Setting server configurations”.
The directory where the server is started becomes the default directory for all server files created by Sybase IQ.
For example, to start the sample database installed with the product, you could use these commands:
% cd $ASDIR/demo % start_asiq @asiqdemo.cfg asiqdemo.db
The server name must not start with a number.
Startup information, which includes the version of Open Client in use, is saved in the stderr log. Output from start_asiq ends with this line:
Server started successfully
For more information, see Sybase IQ System Administration Guide.
If you run the start_asiq utility from $ASDIR/bin, the script changes directory to “./..” to avoid creating database files in the /bin directory.
Using defaults in $ASDIR/scripts/default.cfg, the start_asiq utility sets any required environment variables that have not been set and sets parameters that govern Sybase IQ to the recommended defaults. You may use a configuration file to override these defaults.
If you start your server using any command other than start_asiq, or if your configuration file is encrypted, you must specify the following parameters:
Parameter |
Default 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 time-out set to 72 hours. Prevents users with long queries from being logged off over a long weekend. |
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 -x 'tcpip{port=1870}' asiqdemo.db
The –x parameter here overrides connection information in the asiqdemo.cfg file.
For a complete list and description of startup parameters, see “Starting the database server” in Chapter 1 of Sybase IQ Utility Guide.
If you have Sybase Central, you can use the Start Database Server wizard, as documented in Introduction to Sybase IQ, instead of start_asiq.
On UNIX systems, always run Sybase Central Java and dbisql using
the default colors of the Common Desktop Environment. Running these
products under Open Windows or changing the default colors may cause
display problems.
The server process runs in the background. It sends output to a server log file, $ASLOGDIR/servername.NNN.srvlog where NNN is the number of times the server has been started. For example, $ASLOGDIR/fiona.123.srvlog.
When hyperthreading is on (the default), any system call that requests the number of threads returns twice the number of physical CPUs. Use the -iqnumbercpus parameter to set the number of CPUs returned. You should set this to the number of usable CPUs on your machine.
