MaxConnsPerServer
The MaxConnsPerServer
attribute sets the maximum number of concurrent connections to the server which the DSN references.
If you want to support many connections to the server, you must ensure that the per-process file descriptor limit for the UID
that TimesTen is being run as is set to a value somewhat more than the number of concurrent child servers that are active. This is the number of anticipated concurrent client connections divided by MaxConnsPerServer
. For full details on MaxConnsPerServer
, see Connection Attributes for Data Manager DSNs or Server DSNs in the Oracle TimesTen In-Memory Database Operations
Guide.
The value of this attribute takes precedence over the setting of the value of the max_conns_per_server
attribute in the timesten.conf
file. For details, see Specifying Multiple Connections to the TimesTen Server in Oracle TimesTen In-Memory Database Operations
Guide .
For limits on the maximum number of connections to a TimesTen database, see System Limits.
Changes to TimesTen server settings do not occur until the TimeTen server is restarted. To restart 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 MaxConnsPerServer
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 |