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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » The Database Server » The SQL Anywhere database server » Database server options

-gm server option Next Page

-gn server option


Sets the maximum number of tasks that the database server can execute concurrently.

Syntax

{ dbsrv10 | dbeng10 } -gn integer ...

Applies to

All operating systems and servers.

Remarks

This option sets the maximum multiprogramming level of the database server. It limits the number of tasks (both user and system requests) that the database server can execute concurrently. If the database server receives an additional request while at this limit, the new request must wait until an executing task completes.

The maximum number of combined unscheduled and active requests is limited by the -gm server option, which limits the number of connections to the server.

The default value is 20 active tasks for both the network database server and the personal database server, except on Windows CE where the default is 3, and the number of active tasks that can execute simultaneously depends on the number of database server threads and the number of logical processors in use.

The database server's kernel uses tasks as the scheduling unit. The execution of any user request requires at least one task. However, a request may cause the scheduling of additional tasks on its behalf. One example of this is if the request involves the execution of a Java stored procedure or function that in turn makes database requests back into the database server.

When intra-query parallelism is involved, each access plan component executed in parallel is a task. Consequently, these tasks count toward the -gn limit as if they were actually separate requests. However, tasks created for intra-query parallelism are not reflected in the database properties that track the number of active and inactive requests.

See also