TTC_Server_DSN2, TTC_Server

For TimesTen Classic, this attribute specifies the Server DSN on the computer running the TimesTen server. (This is unnecessary for TimesTen Scaleout.) This is the Server DSN to be used if an automatic failover occurs. See the description of TTC_Server_DSN for details on setting the value of this attribute and associated attributes.

If a failover occurs, if the client cannot connect to TTC_Server_DSN or loses the connection to the DSN, it attempts to connect to TTC_Server_DSN2 or TTC_Server_DSNn.

Unspecified values for TTC_Server_DSNn inherit the value of TTC_Server_DSN (or TTC_Server_DSN1). For example, if TTC_Server2 is specified but TTC_Server_DSN2 and TCP_Port2 are not, then TTC_Server_DSN2 is set to the TTC_Server_DSN value and TCP_Port2 is set to the TCP_Port value.

See Using Automatic Client Failover in Oracle TimesTen In-Memory Database Operations Guide for more information on automatic client failover.

Required Privilege

No privilege is required to change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set TTC_Server_DSN2 or TTC_Server_DSNn 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	`TTC_Server_DSN2`, `TTC_Server_DSNn`	Character string specifying the DSN that resides on the server to be used if an automatic failover occurs.
Windows ODBC Data Source Administrator	Failover Server DSN field (only for `TTC_Server_DSN2`) on the Oracle TimesTen Client DSN Setup dialog.	Character string specifying the DSN that resides on the server to be used if an automatic failover occurs.