Sybase IQ 启动参数
start_iq Server Options
Available switches for the start_iq <server-options> parameters.
In this section:@data database server option
- Reads in options from the specified environment variable or configuration file.
@envvar Database Server Option
- Reads in command-line switches from the supplied environment variable.
@filename Database Server Option
- Reads in switches from configuration file.
- Extends LOGIN_MODE for LDAPUA only to a select number of users using Standard authentication.
- Sets initial memory reserved for caching catalog store pages and other server information.
- Enforces a static cache size.
- Collects information about database pages to be used for cache warming the next time the database is started.
- Sets catalog store cache size upper limit in bytes.
- Sets a minimum cache size as a lower limit to dynamic cache resizing.
- Specifies an additional set of directories or JAR files in which to search for classes.
- Reloads (warms) the cache with database pages using information collected the last time the database was run.
- Displays statistics related to dynamic cache sizing in the database server messages window.
- Controls the appearance of messages about cache warming in the database server messages window.
- Specifies the directory where temporary files are stored.
- Uses transport layer security or simple obfuscation to encode communication protocol packets (such as DBLIB and ODBC) transmitted to and from all clients. TDS connections are not encoded with this option.
- Prompts the user for the encryption key upon starting a strongly encrypted database.
- Allows unencrypted connections over shared memory.
- Sets the database server to use FIPS-certified encryption for strong database and communication encryption.
- Unloads the database after the last non-HTTP client connection disconnects.
- Sets the server process priority class.
- Sets the maximum interval between checkpoints.
- Sets the privileges required to start or stop a database on a running database server.
- Sets the stack size for external functions.
- Disables firing of triggers by the server.
- Sets the privileges required to stop the database server.
- Sets the permission required to load data using
LOAD TABLE
- .
- Limits the number of concurrent connections to the database server.
- Sets the number of execution threads that are used for the catalog store and connectivity while running with multiple users.
- Sets the maximum allowed database page size.
- Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.
- Sets, in part, the stack size for server execution threads that execute requests for server connections.
- Sets the maximum number of physical processors that can be used (up to the licensed maximum). This option is only useful on multiprocessor systems.
- Controls the maximum processor concurrency that the database server allows.
- Sets the privilege required for executing database file administration statements such as for creating or dropping databases.
-iqfrec Database Server Option
- Opens database in forced recovery mode.
-iqgovern Database Server Option
- Sets the number of concurrent queries allowed by the server.
- Enables high-resolution timing for the
iqmsg
- IQ message log file.
- Specifies the maximum amount of memory in MB that
SAP IQ
- can dynamically request from the operating system for temporary use.
- Specifies the main IQ store buffer cache size, in MB.
- Controls the number of threads that
SAP IQ
- uses during point-in-time recovery operations.
-iqmpx_failover Database Server Option
- Initiates multiplex coordinator failover to establish the designated failover Secondary node as the new coordinator.
-iqmpx_ov Database Server Option
- Performs multiplex configuration override for the current node.
-iqmpx_reclaimwriterfreelist Database Server Option
- The coordinator forcefully reclaims the free-list of the writer node identified by
<server-name>
- . This option applies only while restarting a coordinator node.
-iqmpx_sn Database Server Option
- Runs the current node in multiplex in single-node mode.
-iqmsgnum Database Server Option
- Specifies the number of archives of the old message log maintained by the server.
-iqmsgsz Database Server Option
- Limits the maximum size of the message log.
- Specifies the number of
SAP IQ
- threads to create.
-iqnotemp Database Server Option
- Creates a temporary file in place of the defined temporary dbspace.
-iqnumbercpus Database Server Option
- Specifies the number of CPUs available to
SAP IQ
- , overriding the physical number of CPUs, for resource planning purposes.
-iqpartition Database Server Option
- Sets the number of IQ main and temp buffer cache partitions.
-iqrlvmem Database Server Option
- Specifies the amount of memory, in megabytes, available to the RLV store.
- Runs the current node read-only.
-iqstart Database Server Option
- Provides startup diagnostics for dbspaces.
- Specifies IQ temporary store cache size, in MB.
- 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 Database Server Option
- Creates a pool of “wired” memory on HP and Sun UNIX systems.
- Controls the collection of Windows Performance Monitor statistics and statement performance summary statistics.
- 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 database server option (deprecated)
- Specifies the realm of the Kerberos server principal and enables Kerberos authenticated connections to the database server.
- Enables Kerberos-authenticated connections to the database server.
- Disables the creation of shared memory that the Windows Performance Monitor uses to collect counter values from the database server.
- Specifies the maximum number of connections that the Windows Performance Monitor can monitor.
- Specifies the maximum number of databases that the Windows Performance Monitor can monitor.
- Truncates the transaction log when a checkpoint is done.
- Sets the name of the database server.
- Prints all database server messages to the database server message log file.
- Specifies a file name to log startup errors, fatal errors, and assertions.
- 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.
- Specifies a maximum size for the database server message log file, at which point the file is renamed.
- Truncates the database server message log file and appends output messages to it.
- Sets the maximum size of communication packets.
- Compresses all connections except for same-computer connections.
- Sets history tracking for specified database server properties.
- Sets the maximum amount of memory to use for tracking property history, in allotted time or bytes.
- Increases or decreases the size limit at which TCP/IP packets are compressed.
- Controls whether database server system tray icon and database server messages window appear.
- Specifies that messages about performance do not appear in the database server messages window.
- Suppresses startup error windows.
- Specifies that the database server messages window does not appear.
- Sets the user ID for Syslog messages.
- Specifies how the database server reacts to broadcasts.
- Controls whether users have access to features for databases running on the current database server.
- Creates the SYSTEM secured feature key and sets the authorization code for it. This permits access to features that are secured for the database server.
- Sets the user ID and password for the utility database (utility_db), or disables connections to the utility database.
- Sets the TDS login mode.
- Disconnects inactive connections.
- Sets the period at which to send liveness packets.
- Forces transaction manager recovery for distributed transactions.
- Shuts down the server at a specified time.
- Opens files using the operating system disk cache.
- (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.
- Specifies the action that the database server takes when a fatal error or assertion failure occurs on a database server.
- Specifies the action that the database server takes when a fatal error or assertion failure occurs on a database.
- (UNIX servers) Causes the server to touch catalog store temporary files at intervals specified by
<min>
- .
- Displays the database server version in a message box (Windows) or in a version string (UNIX/Linux).
- Specifies server-side network communications protocols.
- Prevents the database server from becoming the default database server.
- Specifies server-side web services communications protocols.
- Displays diagnostic communication messages, and other messages, for troubleshooting purposes.
- Displays database server environment variables in the database server messages window.
- Turns on capturing of the most recently prepared SQL statement for each connection to databases on the server.
- Specifies the number of request log file copies to retain.
- Redirects request logging information to a file separate from the regular log file.
- Redirects web service client information to a file.
- Enables request logging of operations.
- Limits the size of the request log.
