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

dedicated_task option

Dedicates a request handling task to handling requests from a single connection.

Allowed values

On, Off

Default

Off

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

When the dedicated_task connection option is set to On, a request handling task is dedicated exclusively to handling requests for the connection. By pre-establishing a connection with this option enabled, you can gather information about the state of the database server if it becomes otherwise unresponsive.

Example
DROP USER admin;
CREATE USER ADMIN IDENTIFIED BY sql;
GRANT SET ANY SYSTEM OPTION TO admin;

CREATE OR REPLACE PROCEDURE dba.admin_login_procedure ()
BEGIN
    SET TEMPORARY OPTION dedicated_task='on';
END;

GRANT EXECUTE ON dba.admin_login_procedure TO ADMIN;

SET OPTION admin.login_procedure = 'dba.admin_login_procedure';