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.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.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 |
|
A value between 1 and 2047. The default is |
Windows ODBC Data Source Administrator |
Not applicable |