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.

Switch

Description

-dh

Hide the database from dblocate -d.

-ds dir

Specify the directory containing all dbspaces.

-ek key

Specify database encryption key.

-m

Truncate transaction log after checkpoint

-n name

Name the database

There are two -n switches.The -n switch is positional. If this switch appears after a database file name, the switch is a database switch. Otherwise, -n is a server switch.

-sm name

Alternate server name for this database when acting as a read-only mirror.

-sn name

Alternate server name for this database.

-r

Read-only mode. Database modifications are not allowed.