Sybase 12.4.2 manual Starting the server on Unix, Running Adaptive Server IQ

CHAPTER 2 Running Adaptive Server IQ

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.

23