start_iq Server Options

Available switches for the start_iq server-options parameters.

• @data iqsrv16 database server option
  Reads in options from the specified environment variable or configuration file.
• @envvar iqsrv16 Server Option
  Reads in command-line switches from the supplied environment variable.
• @filename iqsrv16 Server Option
  Read in switches from configuration file.
• -c iqsrv16 Server Option
  Sets initial memory reserved for caching catalog store pages and other server information.
• -al iqsrv16 Server Option
  Extends LOGIN_MODE for LDAPUA only to a select number of users using Standard authentication
• -ca iqsrv16 database server option
  Enforces a static cache size.
• -cc iqsrv16 database server option
  Collects information about database pages to be used for cache warming the next time the database is started.
• -ch iqsrv16 Server Option
  Set catalog store cache size upper limit in bytes.
• -cl iqsrv16 database server option
  Sets a minimum cache size as a lower limit to dynamic cache resizing.
• -cp iqsrv16 database server option
  Specifies an additional set of directories or JAR files in which to search for classes.
• -cr iqsrv16 database server option
  Reloads (warms) the cache with database pages using information collected the last time the database was run.
• -cs iqsrv16 database server option
  Displays statistics related to dynamic cache sizing in the database server messages window.
• -cv iqsrv16 database server option
  Controls the appearance of messages about cache warming in the database server messages window.
• -dt iqsrv16 database server option
  Specifies the directory where temporary files are stored.
• -ec iqsrv16 database server option
  Uses transport-layer security or simple encryption to encrypt all command sequence communication protocol packets (such as DBLib and ODBC) transmitted to and from all clients. TDS packets aren't encrypted.
• -ep iqsrv16 database server option
  Prompts the user for the encryption key upon starting a strongly encrypted database.
• -es iqsrv16 database server option
  Allows unencrypted connections over shared memory.
• -fips iqsrv16 database server option
  Requires that only FIPS-certified algorithms can be used for strong database and communication encryption.
• -ga iqsrv16 database server option
  Unloads the database after the last non-HTTP client connection disconnects.
• -gb iqsrv16 database server option
  Sets the server process priority class.
• -gc iqsrv16 database server option
  Sets the maximum interval between checkpoints.
• -gd iqsrv16 database server option
  Sets the privileges required to start or stop a database on a running database server.
• -ge iqsrv16 database server option
  Sets the stack size for external functions.
• -gf iqsrv16 database server option
  Disables firing of triggers by the server.
• -gk iqsrv16 database server option
  Sets the privileges required to stop the database server.
• -gl iqsrv16 Server Option
  Set the permission required to load data using LOAD TABLE.
• -gm iqsrv16 database server option
  Limits the number of concurrent connections to the database server.
• -gn iqsrv16 Server Option
  Sets the number of execution threads that are used for the catalog store and connectivity while running with multiple users.
• -gp iqsrv16 database server option
  Sets the maximum allowed database page size.
• -gr iqsrv16 Server Option
  Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.
• -gss iqsrv16 Server Option
  Sets, in part, the stack size for server execution threads that execute requests for server connections.
• -gt iqsrv16 database server option
  Sets the maximum number of physical processors that can be used (up to the licensed maximum). This option is only useful on multiprocessor systems.
• -gtc iqsrv16 database server option
  Controls the maximum processor concurrency that the database server allows.
• -gu iqsrv16 database server option
  Sets the privilege required for executing database file administration statements such as for creating or dropping databases.
• -iqfrec iqsrv16 Server Option
  Open database in forced recovery mode.
• -iqgovern iqsrv16 Server Option
  Sets the number of concurrent queries allowed by the server.
• –iqlm iqsrv16 Server Option
  Specifies the maximum amount of memory in MB that SAP Sybase IQ can dynamically request from the operating system for temporary use.
• -iqmc iqsrv16 Server Option
  Specifies the main IQ store buffer cache size, in MB.
• -iqmpx_failover iqsrv16 Server Option
  Initiates multiplex coordinator failover to establish the designated failover Secondary node as the new coordinator.
• -iqmpx_ov iqsrv16 Server Option
  Performs multiplex configuration override for the current node.
• -iqmpx_reclaimwriterfreelist iqsrv16 Server Option
  This option applies only while restarting a coordinator node.
• -iqmpx_sn iqsrv16 Server Option
  Runs the current node in multiplex in single-node mode.
• -iqmsgnum iqsrv16 Server Option
  Specifies the number of archives of the old message log maintained by the server.
• -iqmsgsz iqsrv16 Server Option
  Limits the maximum size of the message log.
• -iqmt iqsrv16 Server Option
  Specifies the number of SAP Sybase IQ threads to create.
• -iqnotemp iqsrv16 Server Option
  Creates a temporary file in place of the defined temporary dbspace.
• -iqnumbercpus iqsrv16 Server Option
  Specifies the number of CPUs available to SAP Sybase IQ, overriding the physical number of CPUs, for resource planning purposes.
• -iqpartition iqsrv16 Server Option
  Sets the number of IQ main and temp buffer cache partitions.
• -iqrlvmem start_iq Server Option
  Specifies the amount of memory, in megabytes, available to the RLV store.
• -iqro iqsrv16 Server Option
  Runs the current node read-only.
• -iqstart iqsrv16 Server Option
  Provides startup diagnostics for dbspaces.
• -iqtc iqsrv16 Server Option
  Specifies IQ temporary store cache size, in MB.
• -iqtss iqsrv16 Server Option
  Specifies the stack size, in KB, for server execution threads running either in the background or as part of a thread team assisting the main server connection thread.
• -iqwmem iqsrv16 Server Option
  Creates a pool of “wired” memory on HP and Sun UNIX systems.
• -k iqsrv16 database server option
  Controls the collection of Performance Monitor statistics.
• -kl iqsrv16 database server option
  Specifies the file name of the Kerberos GSS-API library (or shared object on Unix) and enables Kerberos authenticated connections to the database server.
• -kr iqsrv16 database server option (deprecated)
  Specifies the realm of the Kerberos server principal and enables Kerberos authenticated connections to the database server.
• -krb iqsrv16 database server option
  Enables Kerberos-authenticated connections to the database server.
• -ks iqsrv16 database server option
  Disables the creation of shared memory that the Performance Monitor uses to collect counter values from the database server.
• -ksc iqsrv16 database server option
  Specifies the maximum number of connections that the Performance Monitor can monitor.
• -ksd iqsrv16 database server option
  Specifies the maximum number of databases that the Performance Monitor can monitor.
• -m iqsrv16 database server option
  Truncates the transaction log when a checkpoint is done.
• -n iqsrv16 database server option
  Sets the name of the database server.
• -o iqsrv16 database server option
  Prints all database server messages to the database server message log file.
• -oe iqsrv16 database server option
  Specifies a file name to log startup errors, fatal errors, and assertions.
• -on iqsrv16 database server option
  Specifies a maximum size for the database server message log, after which the file is renamed with the extension .old and a new file is started.
• -os iqsrv16 database server option
  Specifies a maximum size for the database server message log file, at which point the file is renamed.
• -ot iqsrv16 database server option
  Truncates the database server message log file and appends output messages to it.
• -p iqsrv16 database server option
  Sets the maximum size of communication packets.
• -pc iqsrv16 database server option
  Compresses all connections except for same-computer connections.
• -pt iqsrv16 database server option
  Increases or decreases the size limit at which packets are compressed.
• -qi iqsrv16 database server option
  Controls whether database server system tray icon and database server messages window appear.
• -qp iqsrv16 database server option
  Specifies that messages about performance do not appear in the database server messages window.
• -qs iqsrv16 database server option
  Suppresses startup error windows.
• -qw iqsrv16 database server option
  Specifies that the database server messages window does not appear.
• -s iqsrv16 database server option
  Sets the user ID for Syslog messages.
• -sb iqsrv16 database server option
  Specifies how the database server reacts to broadcasts.
• -sf iqsrv16 database server option
  Controls whether users have access to features for databases running on the current database server. A secured feature can only be accessed by a user with appropriate privileges, while an unsecured feature can be accessed by all users.
• -sk iqsrv16 database server option
  Specifies a system secure feature key that can be used to allow access to features that are secured for the database server.
• -su iqsrv16 database server option
  Sets the password for the DBA user of the utility database (utility_db), or disable connections to the utility database.
• -tdsl iqsrv16 database server option
  Sets the TDS login mode.
• -ti iqsrv16 database server option
  Disconnects inactive connections.
• -tl iqsrv16 database server option
  Sets the period at which to send liveness packets.
• -tmf iqsrv16 database server option
  Forces transaction manager recovery for distributed transactions.
• -tq iqsrv16 database server option
  Shuts down the server at a specified time.
• -u iqsrv16 database server option
  Opens files using the operating system disk cache.
• -ud iqsrv16 Server Option
  (UNIX servers) Causes the process to run as a daemon in the root directory. SAP recommends that you do not use this switch in IQ servers.
• -uf iqsrv16 database server option
  Specifies the action that the database server takes when a fatal error or assertion failure occurs on a database server.
• -ut iqsrv16 Server Option
  (UNIX servers) Causes the server to touch catalog store temporary files at intervals specified by min.
• -v iqsrv16 Server Option
  Displays the database server version in a message box (Windows) or in a version string (UNIX / Linux).
• -x iqsrv16 database server option
  Specifies server-side network communications protocols.
• -xd iqsrv16 Server Option
  Prevents the database server from becoming the default database server.
• -xs iqsrv16 database server option
  Specifies server-side web services communications protocols.
• -z iqsrv16 database server option
  Displays diagnostic communication messages, and other messages, for troubleshooting purposes.
• -ze iqsrv16 database server option
  Displays database server environment variables in the database server messages window.
• -zl iqsrv16 database server option
  Turns on capturing of the most recently-prepared SQL statement for each connection to databases on the server.
• -zn iqsrv16 database server option
  Specifies the number of request log file copies to retain.
• -zo iqsrv16 database server option
  Redirects request logging information to a file separate from the regular log file.
• -zoc iqsrv16 database server option
  Redirects web service client information to a file.
• -zr iqsrv16 database server option
  Enables request logging of operations.
• -zs iqsrv16 database server option
  Limits the size of the request log.