Switch
|
Description
|
@filename
|
Read
in switches from configuration file.
|
@envvar
|
Read
in switches from environment variable.
|
-c cache-size
|
Set
initial catalog store cache size.
|
-ca 0
|
Disable
dynamic catalog store cache resizing.
|
-cc {+|-}
|
Enable
or disable page collection for cache warming.
|
-ch size
|
Set
catalog store cache size upper limit in bytes.
|
-cl size
|
Set
the cache size lower limit in bytes.
|
-cm size
|
Set
Address Windowing Extensions address space size.
|
-cp
|
Set
search path for classes
|
-cr {+|-}
|
Enable
or disable cache warming.
|
-cs
|
Display
cache sizing statistics.
|
-cv {+|-}
|
Enable
or disable cache warming status messages.
|
-cw
|
Enable
use of Address Windowing Extensions on Windows 2000, Windows XP,
and Windows Server 2003 for setting the size of the database server
cache.
|
-dt dir
|
Directory
for temporary files.
|
-ec encryption-options
|
Enable
packet encryption on the network server.
|
-ep
|
Displays
a dialog box that prompts you for an encryption key to start an encrypted
database. Provides extra security by never allowing the encryption key to be
seen in clear text.
|
-es
|
Allow
unencrypted shared memory connections.
|
-f
|
Force
database to start without transaction log.
|
-fc file
|
File
name of DLL with filesystem full callback function.
|
-fips
|
All
strong encryption done using FIPS-approved modules. This switch requires the
IQ_SECURITY license.
|
-ga
|
Automatically
shut down database after last connection closed.
|
-gb level
|
(Windows)
Set database process priority class to level
].
|
-gc num
|
Set
checkpoint timeout period to num minutes.
|
-gd level
|
Set
the permission required to start and stop the database.
|
-ge size
|
(Windows)
Sets the stack size for threads that run external functions.
|
-gf
|
Disable
trigger firing.
|
-gk level
|
Set
the permission required to stop the server.
|
-gl level
|
Set
the permission required to load data.
|
-gm num
|
Set
the total number of connections that the server can support at one time. If
this number is greater than the number that is allowed under licensing
constraints, this option has no effect. The value should approximate the
number of users expected to connect to the server. Some connections are
expected to be idle, while other connections are actively using the database.
The default is 10 connections.
|
-gn integer
|
Set
the number of execution threads to be used for the catalog store and
connectivity while running with multiple users. Sybase recommends that you
set the -gn value to at least 1.5 times
the value of -gm.
|
-gp size
|
Set
maximum page size to size bytes. size
must be to the power of 2.
|
-gr num
|
Set
maximum recovery time to num minutes.
|
-gss {integer
| integerK | integerM}
|
Sets
the stack size per SQL Anywhere thread in the server. Has no effect on
Windows. The default is 64KB. The maximum size is 4MB.
|
-gt num
|
Set
maximum number of physical processors to use (up to licensed maximum).
|
-gtc num
|
Set
maximum processor concurrency (cores and hyperthreads).
|
-gu level
|
Utility
commands permission level: utility_db, all, none,
dba.
|
-iqfrec dbname
|
Open
database in forced recovery mode.
|
-iqgovern num
|
Specify
the number of concurrent queries.
|
-iqmc size
|
Specify
the main cache size, in MB. (Overrides default)
|
-iqsmem size
|
Create
a memory pool to increase heap space.
|
-iqmsgnum num
|
Specifies the number of archives of the old message log maintained
by the server. Allowed values are integers 0 – 64 (inclusive). Default value
is 0, which means that messages are wrapped in the main message log file.
Takes effect only if -iqmsgsz or the IQMsgMaxSize server property is a value other than zero.The IQMsgNumFiles server
property corresponds to -iqmsgnum and takes precedence over the value of -iqmsgnum. For
information on the IQMsgNumFiles server property, see “sa_server_option
system procedure” in Chapter 7,
“System Procedures” of Reference: Building Blocks, Tables, and Procedures.
|
-iqmsgsz size
|
Limits
the maximum size of the message log. Allowed values are integers 0-2047
(inclusive) in megabytes. The default value is 0, which specifies no limit on
the size of the message file.
|
-iqmt num
|
Specify
the number of threads that IQ can use on a multi-threaded system. The default
is (60*numCPUS)+(2*num_conn)+5. The minimum value is 2*num_conn+5.
|
-iqnotemp size
|
Create
a temporary file in place of the defined temporary dbspace. The argument to
the switch specifies the file size in MB.
|
-iqnumbercpus
|
Override
the number of physical CPUs with the number available to IQ.
|
-iqpartition
|
Specify
number of partitions in main and temp buffer caches.
|
-iqsmem size
|
Create
a memory pool to increase heap space.
|
-iqstart N
|
Provide
startup diagnostics for dbspaces.
|
-iqtc size
|
Specify
temporary cache size, in MB. (Overrides default.)
|
-iqtss size
|
Specify
the thread stack size, in KB.
|
-iqwmem size
|
Specify
the size, in MB, of a special memory pool that cannot be paged for HP and Sun
UNIX platforms.
|
-k
|
Instructs
Sybase IQ to not collect performance statistics.
|
-kl file
|
File
name for Kerberos GSS-API library.
|
-kr realm
|
Realm
for Kerberos server principal.
|
-krb
|
Enable
Kerberos authentication. This switch requires the IQ_SECURITY license.
|
-ks 0
|
Disable
creating performance statistic shared memory.
|
-ksc num
|
Number
of connections to be tracked by the performance statistic. The default is 2.
|
-ksd num
|
Number
or databases to be tracked by the performance statistic. The default is 10.
|
-m
|
Truncate
transaction log after checkpoint.
|
-n name
|
Use
name as the name of the database
server.
There are two -n options. If -n appears
after a database file name, the meaning is different.
|
-o filename
|
Output
server messages to the specified file.
|
-oe filename
|
Set
file name to log startup errors, fatal errors, and assertions.
|
-on size
|
Appends
“.old” to the log file name and starts a new log file with the original name
when the log reaches the specified size.
|
-os
|
Specify
maximum size of file for server messages.
|
-ot file
|
File
name for copy of message window.
|
-p packet-size
|
Set
maximum network packet size.
|
-pc
|
Compress
communication packets.
|
-pt size
|
Set
compression threshold.
|
-qi
|
(Windows)
Control whether database server tray icon and window appear.
|
-qp
|
Do
not display messages about performance in the database server window.
|
-qs
|
(Windows)
Suppress startup error dialogs.
|
-qw
|
Do
not display database server screen.
|
-s
|
Set
the syslog facility ID (none, user, daemon, local0,..., local7) [UNIX].
|
-sb {0 | 1}
|
Specify
how the server reacts to broadcasts on TCP/IP.
|
-sf name
|
Comma-separated
list of features or feature sets to be secured.
|
-sk
key
|
Key
allowing overriding of secured features.
|
-su
password
|
Specify
password for utility_db, or specify “none” to disable utility_db.
|
-ti min
|
Client idle time before shutdown:—default 4400 minutes.
|
-tl sec
|
Default
liveness timeout for clients in seconds—default is 120 seconds.
|
-tmf
|
Force
transaction manager recovery.
|
-tq time
|
Set
quitting time.
|
-u
|
Use
buffered disk I/O.
|
-ud
|
Causes
the process to run as a daemon in the root directory [UNIX].
|
-uf
|
Specifies
the action to take when a fatal error occurs [UNIX].
|
-ut min
|
Touch
temporary files every min minutes
[UNIX].
|
-v or -v2
|
Display
database server version.
|
-x list
|
Comma-separated
list of communication links to try.
|
-xs
|
Specify
server-side Web services communications protocols.
|
-z
|
Provide
diagnostic information on communication links.
|
-ze
|
Display
server environment variables.
|
-zl
|
Capture
most-recently prepared SQL statement for each connection to a database on the
server.
|
-zn num
|
Number
of request log files to keep.
|
-zo
|
Specify
file for logging server requests.
|
-zoc file
|
Output
HTTP Web client procedure debug log to file.
|
-zr level
|
Enable
server request-level logging.
|
-zs {integer | integerG | integerK | integerM }
|
Specify
maximum size of file for server request logging.
|
