Sybase 12.4.2 User Manual

Page 49

Advertising
background image

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

Advertising