ServersPerDSN

The ServersPerDSN attribute specifies the number of child server processes for a particular server DSN that will use round-robin connection distribution.

This attribute only has any effect if the TimesTen server is configured to operate in multithreaded mode (MaxConnsPerServer > 1). If ServersPerDSN is set to 1 then the first MaxConnsPerServer client connections to the server DSN will be assigned to one child server process, the next MaxConnsPerServer connections to a second child server process and so on. See Connection Attributes for Data Manager DSNs or Server DSNs in the Oracle TimesTen In-Memory Database Operations Guide for more details.

The value of this attribute takes precedence over the setting of the value of the servers_per_dsn attribute in the timesten.conf file. For details, see Specifying Multiple Connections to the TimesTen Server in the Oracle TimesTen In-Memory Database Operations Guide.

Changes to TimesTen server settings do not occur until the TimesTen server is restarted. To restart the server, use the command ttDaemonAdmin -restartserver.

Required Privilege

Only a user with operating system privileges on the system DSN in which this attribute is defined can change the value of this attribute to a value other than the one currently in effect.

Setting

Set ServersPerDSN as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen

ServersPerDSN

A value between 1 and 2047. The default is 1.

Windows ODBC Data Source Administrator

Not applicable