The startup switches for IQ can be confusing - as your are affecting to database servers, 1) the SQL Anywhere/ASA Catalog Store, 2) the IQ Database Server.
These are sorted in importance, or impact on the overall server. We'd like to see Sybase improve the names of these switches (gm = user connections .. really?)
Connectivity parameters, typically just the port setting.
-x tcpip{port=5666}
Log file location (this is the server's message log, not the transaction log); zn = number of log files to keep.
-o /opt/sybase/iq/msglogs/HELENA.srvlog
-zn 4
The Catalog Store buffer cache / memory pool for the Catalog Store (ASA server).
-- Set a lower limit of 500mb, and upper limit of 1 GB
-cl 512m
-ch 1024m
-- Set/pin allocation to 1 GB
-c 1024m
The Catalog Store (ASA server) page size.
-gp 4096
Main cache and Temp cache settings, in MB. Avoid allocating more than 75% of the host memory.
-- Host has 128 GB of memory, so we will allocate 96 GB to IQ.
-iqmc 46000
-iqtc 50000
Number of processes / user connections. Each connection takes about 10mb. Do not over-allocate.
-gm 125
Set number of cache partitions.
Note: By default, Sybase IQ computes the number of partitions automatically as #Processors/8, rounded to the nearest power of 2
-iqpartition 4
Limit the number of active queries/processes (processes will queue up as appropriate).
This setting should be left for the system to decide; systems with CPU saturation issues typically implement this setting.
Default calculation for this parameter is: 2*(#Processors) + 10
-iqgovern 46
Set the number of threads for the IQ server.
This setting should be left for the system to decide; systems with CPU saturation issues typically implement this setting.
Base calculation for this setting is
60*4 + 50*(#Processors - 4) + 2*(#Connections + 2) + 1
so for an 8 CPU dual Core system, with 100 user connections, the calc would be
60*4 + 50*(16 - 4) + 2*(100 + 2) + 1 = 1045
-iqmt 2500
Threads used by Catalog Store (ASA server) - used when user connection has active query.
Rule of thumb: -gn should be => -gm+5 and -iqgovern also should be > -gm.
-gn 300
Stack size, internal execution threads, IQ server
-iqtss 256
Stack size, internal execution threads, (ASA server)
-gss
Recovery time in minutes, affects checkpoint frequency
-gc 30
-gr 30
Set the number of CPUs available to IQ. Note that for licensing, it is best to set the CPU count in the BIOS of the host.
-gt 8
-iqnumberofcpus 8
Set login allowed to start/stop server & create databases. Best to leave these to DBA.
-gd DBA
-gk DBA
-gu DBA
Set login(s) available to run LOAD TABLE
-gl all
Timeout for idle IQ connections, in minutes
-ti 4400
UNIX/syslog related switch (ID, max files size for server messages)
-s none
-os 1000 # log file related
Request-level logging - set these only for brief periods, where troubleshooting is required.
-zo /opt/sybase/iq/msglogs/HELENA.monsql.txt
-zr SQL
-zs 10m
|
|
