Sybase IQ 12.4.0 Server User Manual


 
-gm command line option Adaptive Server IQ 12.4.0
16
Release Bulletin for Digital UNIX
The
-iqmt switch is not set by start_asiq on Digital UNIX systems. The setting
listed in the Adaptive Server IQ Administration and Performance Guide and
the Adaptive Server IQ Installation and Feature Guide is incorrect. The default
value is calculated from the number of connections and the number of CPUs,
and is usually adequate.
9.1.4 -gm command line option
The description of the server parameter -gm in the Adaptive Server IQ
Reference Manual should read as follows.
-gm
num
Limit the number of connections to the server that can be active
at one time. If this number is greater than the number that is allowed under
licensing constraints, it has no effect. The value should approximate the
number of users expected to connect to the server.
9.1.5 -gn command-line option
The -gn server parameter should be added to Chapter 2 of the Adaptive Server
IQ Reference Manual and to “Controlling performance from the command
line” in Chapter 2 of the Adaptive Server IQ Administration and Performance
Guide.
Function
Set the number of execution threads for the Catalog Store.
Syntax asiqsrv12 -gn
integer
...
Applies to
All operating systems and servers.
Description
Set the number of execution threads that will be used for the Catalog Store and
connectivity while running with multiple users.
On Windows NT you need to specify this parameter in the
asiqsrv12
command. To calculate its value use the following formula:
gn_value
=
gm_value
- (( 2 *
num_CPUs
) + 10)
Specify a minimum of 25.
On UNIX platforms, the
start_asiq utility sets this parameter. See the Adaptive
Server IQ Installation and Feature Guide for your platform for more
information.
9.1.6 Using -v switch on 64-bit platforms