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 dbeng12/dbsrv12 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 dbeng12/dbsrv12 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 dbeng12/dbsrv12 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 dbeng12/dbsrv12 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 dbeng12/dbsrv12 server option.

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