Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 43 / 536

CHAPTER 2 Running Adaptive Server IQ
23
You can choose from many command-line options or switches to specify such
features as permissions required to start a database or stop the server, and the
network protocols to use. The command-line switches are one means of tuning
Adaptive Server IQ behavior and performance.
There are slight variations in the basic command for different operating
systems, as well as a startup utility that runs this command automatically. See
the sections that follow for details.
Starting the server on UNIX
This section describes two methods for starting the database server that are
specific to UNIX platforms:
• Use the startup utility
start_asiq
. This is the preferred method.
• Enter the server startup command and the appropriate parameters (see
below).
You can also use any of the generic methods described elsewhere in this
chapter, provided that you set startup parameter defaults for each platform to
the settings used in
start_asiq
. These settings are listed in the Adaptive Server
IQ Installation and Configuration Guide.
Normally, you should always use the
start_asiq
utility to start the server on
UNIX platforms. If you do not, among the tasks you must do which the utility
normally does for you are:
• Remove all limits, and then set limits on the stack size and descriptors. To
do so, go to the C shell and issue these commands:
% unlimit
% limit stacksize 8192
% limit descriptors 4096
Note
Be aware that unlimit affects soft limits only. You must change any
hard limits by setting kernel parameters.
• Set all server parameters appropriately in the
asiqsrv12
command.