Database server startup options

Reads in options from the specified environment variable or configuration file.

Displays usage information.

Allows standard user authentication for specified users.

Uses bulk operation mode.

Sets the initial memory reserved for caching database pages and other database 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.

Starts the Cockpit.

Sets a maximum cache size, as a limit to automatic cache growth.

Sets a maximum cache size as a limit to automatic cache growth.

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.

Turns on database isolation.

Prompts the user for the encryption key upon starting a strongly encrypted database.

Allows unencrypted connections over shared memory.

Forces the database server to start after the transaction log has been lost.

Specifies the file name of a DLL (or shared object on Unix) containing the File System Full callback function.

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 privilege required to load data using the LOAD TABLE statement, and to unload data using the UNLOAD or UNLOAD TABLE statements.

Limits the number of concurrent connections to the database server.

Sets the multiprogramming level of the database server.

Controls automatic tuning of the database server multiprogramming level.

Sets the maximum multiprogramming level - the maximum number of tasks that the network database server can execute concurrently.

Sets the minimum database server multiprogramming level.

Displays statistics for automatic multiprogramming level adjustments in the database server message log.

Sets the maximum allowed database page size.

Sets the maximum length of time (in minutes) for recovery from system failure.

Sets the stack size per worker in the database server.

Sets the maximum number of physical processors that can be used (up to the licensed maximum). This option is only useful on multiprocessor systems.

Sets which logical processors the database server can use.

Controls the maximum processor concurrency that the database server allows.

Turns topology-aware scheduling on or off. This option is only useful on multiprocessor systems.

Sets the privilege required for executing database file administration statements such as for creating or dropping databases.

Runs the database server in memory, reducing or eliminating writes to disk. With the exception of the validation option, in-memory mode requires a separate license.

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.

Specifies the Kerberos server principal and enables Kerberos authenticated connections to the database server.

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.

Enables sending status events to the SAP Solution Manager using the NCS (Native Component Supportability) library.

Enables sending status events to the SAP Solution Manager using the NCS (Native Component Supportability) library, and specifies the location of the NCS configuration file to use.

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.

Writes the process ID into the specified file.

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 the database server messages window is not minimized on startup.

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.

Forces all databases that start on the database server to be read-only.

Sets the user ID for Syslog messages.

Specifies how the database server reacts to broadcasts.

Sets the default disk sandbox settings for all databases started on the database server that do not have explicit disk sandbox settings.

Specifies that the database server uses one CLR external environment for all databases running on the database server

Controls whether users have access to features for databases running on the current database server.

Specifies that the database server uses one Java VM for all databases running on the 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.

Sets a re-enlistment timeout for participation in distributed transactions.

Shuts down the server at a specified time.

Sets up a database server tracing session.

Opens files using the operating system disk cache.

Turns off use of asynchronous I/O.

Starts the database server in shell mode.

Runs the database server as a daemon.

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.

Opens the Server Startup Options window, displays the database server messages window, and starts the database server whether the X window server starts or not.

Displays database server messages in a new window within DBLauncher.app.

Starts the database server in shell mode but suppresses output.

Touches temporary files.

Opens the Server Startup Options window or displays the database server messages window on Linux (use the X window server).

Displays the software version.

Enables and disables the Volume Shadow Copy Service (VSS).

Controls whether checksums are enabled on write operations for all databases on this database server, if the databases do not have checksums enabled by default.

Specifies server-side network communications protocols.

Specifies a comma-separated list of database names and authentication strings for an arbiter server.

Prevents the database server from becoming the default database server.

Specifies the location of the file used for maintaining state information about your database mirroring system.

Specifies how often the database server checks for new IP addresses.

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.

Turns on capturing of the plan most recently used by the query optimizer.

Enables request logging of operations.

Limits the size of the request log.

Turns on logging of request timing information.