start_iq Server Options

Available switches for the start_iq server-options parameters.

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