CHAPTER 2 Running Adaptive Server IQ

Displaying command- line options

Case sensitivity

Using configuration files

For this switch

See this section

-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”

 

 

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.

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 /?

Command-line parameters are case sensitive.

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.

29

Page 49
Image 49
Sybase 12.4.2 manual Case sensitivity Using configuration files