Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

reserved_connections option

Controls the minimum number of concurrent connections that a database must reserve for standard connections. This option is useful when your database server accepts HTTP/HTTPS connections.

Allowed values
  • size

    This integer specifies the number of concurrent connections that the database must reserve for standard connections.

    For databases running on the network database server, specify a number that fulfills the following requirements:

    • Less than the maximum database server connection limit as allowed by your license.

    • Less than the maximum database server connection limit as specified by the -gm database server option.

    • Less than the maximum database connection limit specified by the max_connections database option.

    For the personal database server, specify a number between 3 and 9 .The personal database server (dbeng17) accepts a maximum of 10 concurrent connections, of which a minimum of 3 are always reserved for standard connections.

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes with SET ANY SYSTEM OPTION No No
Allowed to set temporarily? Yes with SET ANY SYSTEM OPTION No No
Remarks

Setting this option ensures that a database can accept standard connections even when its HTTP/HTTPS connections are queued.

A database server accepts HTTP/HTTPS connections until it reaches its license limit, and then it queues subsequent HTTP/HTTPS connections and processes them as connections are made available. There is no opportunity for a standard connection to replace an HTTP/HTTPS connection while there are connection attempts in the queue. Users wanting to make a standard connection, could wait indefinitely for the HTTP/HTTPS connection queue to complete. Use the reserved_connections option to specify a minimum number of number of database connections that can only accept standard connections.

The personal database server always reserves a minimum of 3 connections for standard connections to ensure that standard database connections are not blocked by HTTP connections.

By default, the network database server does not reserve connections.

You can view the current number of reserved connections for a database by querying the value of the reserved_connections connection property:

SELECT CONNECTION_PROPERTY ( 'reserved_connections' );
Example

The following example reserves 10 connections for standard connections.

SET OPTION PUBLIC.reserved_connections=10;