Attribute

SQLEngineMode (sem)

Purpose

Specifies whether the driver's SQL engine runs in the same process as the driver (direct mode), runs in a process that is separate from the driver (server mode), or runs in a separate process that is monitored by the driver's Broker (Broker mode). You must be an administrator to modify the server mode configuration values, and to start or stop the SQL engine service.

Valid Values

0 | 1 | 2 | 3

Behavior

If set to 0 (Auto), the SQL engine attempts to run in server mode first; however, if server mode is unavailable, it runs in direct mode. To use server mode with this value, you must start the SQL Engine service before using the driver (see "Using the SQL engine server" for more information).

If set to 1 (Server), the SQL engine runs in server mode. The SQL engine operates in a separate process from the driver within its own JVM. You must start the SQL Engine service before using the driver (see "Using the SQL engine server" for more information).

If set to 2 (Direct), the SQL engine runs in direct mode. The driver and its SQL engine run in a single process within the same JVM.

Important: Changes you make to the server mode configuration affect all DSNs sharing the service.

If set 3 (Broker), the SQL engine runs in Broker mode. The SQL engine operates in an external Java process that is monitored by the driver's Broker. To efficiently provisions memory and resources, the Broker automatically starts and stops the service as needed. This setting also eliminates the need to manually start and stop the service.

Default Value

For Windows: 1 (Server)

For UNIX/Linux: 2 (Direct)