Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 50 / 536

Using command-line switches
30
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.
Required command-
line switches While most of the command-line switches described in the sections that follow
are optional, you must specify the
-n
,
-c
,
-gp
, and
-gm
switches 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
start_asiq
command line.