Sybase 12.4.2 Server User Manual


 
CHAPTER 2 Running Adaptive Server IQ
29
Some of the values you can set with command-line switches can also be
changed with the
SET OPTION command. For details of this command and its
options, and for a complete list of command-line switches and full reference
information on them, see the Adaptive Server IQ Reference Manual.
Displaying command-
line options
To display all of the available command-line options, enter one of the
following commands at the operating system prompt:
On UNIX systems, enter:
asiqsrv12 -h
On Windows NT systems, enter:
asiqsrv12 /?
Case sensitivity
Command-line parameters are case sensitive.
Using configuration
files
If you use an extensive set of command-line options, you can store them in a
configuration file, and invoke that file on a server command line. Specify
switches in the configuration file as you would on the command line, with
these exceptions:
You can enter switches on multiple lines.
You must not include either single or double quotes in a configuration file.
-gp “Setting a maximum Catalog page size”
-gr “Recovery time”
-gu “Controlling permissions from the command line”
-iqgovern “Concurrent queries”
-iqmc “Buffer caches and physical memory”
-iqtc “Buffer caches and physical memory”
-iqsmem “Unwired memory” (AIX, Compaq Tru64 UNIX, and
HP UNIX only)
-iqwmem “Wired memory” (Compaq Tru64 UNIX, HP UNIX,
and Sun UNIX only)
-n “Naming the server and databases”
-p “Other performance-related switches”
-ti “Setting the default client timeout”
-tl “Setting the default network timeout”
-x “Selecting communications protocols”
-z “Debugging network communications startup
problems”
For this switch See this section