Dbsrv16 options trading


If you supply no options and no database file, then on Windows operating systems a window appears, allowing you to browse to your database file. If you want to start a database server from a batch file, you must use the dbspawn utility. See Start Server in Background utility dbspawn. By default, the personal database server only uses the shared memory protocol. For more information about the differences between the personal database server and the network database server, see Using SQL Anywhere database servers.

By default, the database server page size is the same as the largest page size of the databases on the command line. Once the database server starts, you cannot start a database with a larger page size than the database server. See Maximum page size considerations.

The following command starts the SQL Anywhere sample database running on a personal database server:. The following command starts the SQL Anywhere sample database running on a network database server:. The following example, entered all on one line, starts a database server named myserver that starts with a cache size of 3 MB and loads the sample database:.

SQL Anywhere database server syntax. Server option Description data Reads in options from a configuration file or environment variable. In addition, shut down after the last database is closed. See -gn dbsrv12 server option. See -gna dbsrv12 server option. See -gnh dbsrv12 server option. See -gnl dbsrv12 server option. See -gns dbsrv12 server option.

This option is only useful on multiprocessor systems. The -n option is positional. See -pc dbsrv12 server option. See -pt dbsrv12 server option. See -xa dbsrv12 server option. See -xf dbsrv12 server option. The minimum value is 10 and the default value is 0.

For a portable device, the default value is The default is NONE. Database option Description -a filename Applies the named transaction log file. Database modifications not allowed. See -sm dbsrv12 database option deprecated. See -sn dbsrv12 database option. See -xp dbsrv12 database option. The elements of the database server command include the following: Examples of starting a database server.

The following command starts the SQL Anywhere sample database running on a personal database server: Discuss this page in DocCommentXchange. Reads in options from a configuration file or environment variable. Runs in bulk operations mode. Sets initial cache size. Collects information about database pages to be used for cache warming.

Reserves address space for non-cache use [bit Windows, bit Unix]. Specifies set of directories or JAR files in which to search for classes.

Warms the cache with database pages. Displays cache usage in the database server messages window. Controls the appearance of messages about cache warming in the database server messages window. Enables use of Address Windowing Extensions for setting the size of the database server cache [Windows].

Specifies the directory where temporary files are stored. Enables packet encryption [network server]. Prompts for encryption key. Allows unencrypted connections over shared memory.

Forces the database to start without a transaction log. Specifies the file name of a DLL containing the file system full callback function. Automatically unloads the database after the last non-HTTP client connection is closed. Sets maximum checkpoint timeout period to num minutes. Sets database starting permission. Sets the stack size for threads that run external functions.

Disables firing of triggers. Sets the permission required to stop the server. Sets the permission required to load or unload data. Sets the maximum number of connections. Sets the multiprogramming level of the database server. Controls automatic tuning of the database server multiprogramming level. Sets the maximum number of tasks that the database server can execute concurrently. Sets the minimum number of tasks that the database server can execute concurrently.

Reports multiprogramming level statistics in the database server message log. Sets the maximum page size to size bytes. Sets the maximum recovery time. Sets the thread stack size to size bytes. Sets the maximum number of physical processors that can be used up to the licensed maximum. Controls the maximum processor concurrency that the database server allows. Sets the permission level for utility commands: Runs the database server in memory, reducing or eliminating writes to disk. Controls the collection of Performance Monitor statistics.

Specifies the Kerberos server principal and enable 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. See -sk database server option. See -su database server option. See -tdsl database server option. See -ti database server option. See -tl database server option. See -tmf database server option. See -tmt database server option. See -tq database server option. See -u database server option.

See -ua database server option. See -uc database server option. See -ud database server option. See -uf database server option. See -ufd database server option. See -ui database server option. See -um database server option. See -ut database server option. See -ux database server option. See -v database server option. See -vss database server option. See -wc database server option. See -xa database server option. See -xd database server option. See -xf database server option. The minimum value is 10 and the default value is 0.

For a portable device, the default value is See -xm database server option. See -xs database server option. See -z database server option. See -ze database server option. See -zl database server option. See -zn database server option. See -zo database server option. See -zoc database server option. See -zp database server option. The default is NONE. See -zr database server option. See -zs database server option. See -zt database server option.

Database option Description -a filename Applies the named transaction log file. See -a database option. See -ad database option. See -al database option. See -ar database option. See -as database option. See -dh database option.

See -ds database option. See -ek database option. See -m database option. See -n database option. Database modifications not allowed. See -r database option. See -sbx database option. See -sm database option deprecated. See -sn database option. See -wc database option. See -xp database option. The elements of the database server command include the following: The following command starts the SQL Anywhere sample database running on a personal database server: Examples of starting a database server.

Discuss this page in DocCommentXchange. Reads in options from a configuration file or environment variable. Allow standard user authentication for specified users.

Runs in bulk operations mode. Sets initial cache size. Collects information about database pages to be used for cache warming. Reserves address space for non-cache use [bit Windows, bit Unix]. Specifies set of directories or JAR files in which to search for classes. Warms the cache with database pages.

Displays cache usage 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. Enables packet encryption [network server]. Prompts for encryption key. Allows unencrypted connections over shared memory. Forces the database to start without a transaction log.

Specifies the file name of a DLL containing the file system full callback function. Automatically unloads the database after the last non-HTTP client connection is closed. Sets maximum checkpoint timeout period to num minutes. Sets database starting privilege. Sets the stack size for threads that run external functions. Disables firing of triggers. Sets the privilege required to stop the server. Sets the privilege required to load or unload data. Sets the maximum number of connections.

Sets the multiprogramming level of the database server. Controls automatic tuning of the database server multiprogramming level. Sets the maximum number of tasks that the database server can execute concurrently. Sets the minimum number of tasks that the database server can execute concurrently. Reports multiprogramming level statistics in the database server message log.

Sets the maximum page size to size bytes. Sets the maximum recovery time. Sets the thread stack size to size bytes. Sets the maximum number of physical processors that can be used up to the licensed maximum. Controls the maximum processor concurrency that the database server allows. Sets the privilege level for utility commands: Runs the database server in memory, reducing or eliminating writes to disk. Controls the collection of Performance Monitor statistics.

Specifies the Kerberos server principal and enable 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 Performance Monitor uses to collect counter values from the database server [Windows]. Specifies the maximum number of connections that the Performance Monitor can monitor [Windows].

Specifies the maximum number of databases that the Performance Monitor can monitor [Windows]. Truncates the transaction log after each checkpoint for all databases. Uses name as the name of the database server. Outputs messages to the specified file. Specifies file to log startup errors, fatal errors, and assertions to. Specifies a maximum size for the database server message log file, after which the file is renamed with the extension.

Limits the size of the log file for messages. Truncates the database server message log file and appends output messages to it. Sets the maximum communication packet size [network server]. Compresses all communication packets except same-computer connections.

Sets the minimum network packet size to compress. Does not display the database server system tray icon or database server messages window [Windows]. Does not minimize the database server messages window on startup [Windows and Linux]. Suppresses messages about performance in the database server messages window. Suppresses startup error windows [Windows]. Does not display the database server messages window. Opens database in read-only mode.

Specifies how the server reacts to broadcasts. Controls the default disk sandbox settings for all databases started on the database server that do not have explicit disk sandbox settings.

Secures features for databases running on this database server. Specifies a key that can be used to enable features that are disabled for the database server. Sets the TDS login request mode.

Sets the client idle time before shutdown—default minutes. Sets the default liveness timeout for clients in seconds—default seconds. Forces transaction manager recovery for distributed transactions [Windows]. Sets the re-enlistment timeout for distributed transactions [Windows].

Sets quitting time [network server]. 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 and displays the database server messages window, or starts the database server in shell mode if a usable display isn't available [Linux].

Displays the database server messages window and Server Startup Options window [Linux]. Displays database server version and stop. Enables write checksums for databases running on the database server.