Sybase 12.4.2 manual Elora 16M Tcpipport=2367 -gm Gp 4096 path\mydb.db

start_asiq

Using command-line switches

Required command- line switches

For example, the following configuration file starts the database mydb.db, on the database server named Elora, with a Catalog cache size of 16MB, TCP/IP as a network protocol and a specified port number, user connections limited to 10, and a Catalog page size of 4096 bytes.

-n Elora

-c 16M

-x tcpip(port=2367 -gm 10

-gp 4096 path\mydb.db

If you name the file mydb.cfg, you could use these command-line options as follows:

asiqsrv12 @mydb.cfg

In examples throughout this chapter where there are several command-line options, we show them for clarity on separate lines as they could be written in a configuration file. If you enter them directly on a command line, you must enter them all on one line.

Note When you stop the server with the DBSTOP command, you need to specify the same parameters as when you started the server. Using a configuration file to start the server ensures that you will be able to find these parameters when you need them.

While most of the command-line switches described in the sections that follow are optional, you must specify the -n, -c, -gp, and -gmswitches to run Adaptive Server IQ effectively.

For this release, recommended server startup values are:

asiqsrv12 -n servername -c 16M -gc 6000 -gd all -gm 10 -gp 4096 -gr 6000 -ti 4400 -tl 300 database

If you use TCP/IP to connect to the server, you should include network connection parameters as well. If you start the server without the parameter -x ’tcpip(port=nnnn)’ set, then the server uses the default TCP/IP port number 2638.

On UNIX platforms, if you start the database server with the start_asiq command, these parameters are included automatically with values shown above, along with others specific to your platform. You can override these values and include other parameters by specifying them on the command line.

30