Database server options

Following is a list of enhancements made to database server options in SQL Anywhere version 11.0.0.

  • -es server option   In previous versions of SQL Anywhere, if the database server was started with the -ec option (to support transport layer security), but the list of allowed encryption protocols did not include NONE or SIMPLE, then the shared memory port was not started because it does not support transport layer security. This meant that all connections to the database server had to be made over TCP/IP using strong encryption.

    The -es server option instructs the database server to allow unencrypted connections over shared memory. See -es server option.

  • -gb server option   The -gb server option for controlling the server process priority class is now supported on Unix, as well as Windows. See -gb server option.

  • -im server option   You can run the database entirely in memory if the loss of all database operations is tolerable for your application. This feature is intended for situations where SQL Anywhere is intended to be used as a fast, temporary data-store, where data is inserted at a rapid rate. See -im server option.

  • Reading from and writing to files on a client computer   The -sf server option now allows you to control the ability to read from, and write to, files on a client computer. See -sf server option.

  • -um server option   The -um option allows you to connect to the DBLauncher.app instance, if it is running, and displays database server messages in a new window within DBLauncher.app. This option only applies to Mac OS X. See -um server option.

  • Windows Performance Monitor options   The following server options have been added to further configure the Windows Performance Monitor:

    • -ks option   Disables the creation of shared memory that the Performance Monitor uses to collect counter values from the database server. See -ks server option.

    • -ksc option   Specifies the maximum number of connections that the Performance Monitor can monitor. See -ksc server option.

    • -ksd option   Specifies the maximum number of databases that the Performance Monitor can monitor. See -ksd server option.