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

connection_type database option

Controls whether connections from monitoring applications affect database or database server shutdown.

Allowed values

Event, Internal, Standard, Monitor

The default values are as follows:

  • Standard

    For CmdSeq, TDS, HTTP, and HTTPS connections.

  • Event

    For connections created for event handlers.

  • Internal

    For all other types of connections.

Default

Standard

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? No No No
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
Remarks

For CmdSeq, TDS, HTTP, and HTTPS connections, the supported values are Standard and Monitor.

Connections set to Monitor are ignored when determining whether the conditions have been met for shutting down the database or database server when using one of the following:

  • The Shut down button on the database server messages window.

  • The dbstop utility without the -y option.

  • The STOP DATABASE or STOP SERVER statement without the UNCONDITIONALLY clause.

If a database is configured to automatically stop, connections with connection_type set to Monitor are ignored when determining whether the conditions have been met for automatically stopping the database.

Note

HTTP and HTTPS connections without associated session IDs are always ignored when determining whether the conditions have been met for shutting down the database or database server, even if the connection type is not set to Monitor.

HTTP and HTTPS connections with associated session IDs are only ignored when determining whether the conditions have been met for shutting down the database or database server if the connection type is set to Monitor.

Example

To ensure that the database server ignores your connection when determining whether the conditions have been met for shutting down the database or database server, execute the following statement:

SET TEMPORARY OPTION connection_type = 'Monitor';