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 odbc.ini file in TimesTen Classic or in the database definition (.dbdef) file in TimesTen Scaleout	MaxConnsPerServer	A value between 1 and 2047. The default is 1, which indicates that each connection has its own separate process, not just a separate thread within a process.
Windows ODBC Data Source Administrator	Not applicable