TTC_Random_Selection

Specifies that the TimesTen client, if necessary, selects an alternative server from the list provided in TTC_ServerN attribute settings. If the client cannot connect to the selected server, it keeps redirecting until it successfully connects to one of the listed servers. If the client cannot connect to any of the selected servers, TimesTen returns an error.

• 1 (default): Initially, the list of failover servers provided by TTC_ServerN connection attributes is randomized. After which, the client selects sequentially from the randomized list for the initial connection and then for any client failover request.

• 0: Client selects the first server specified by the TTC_ServerN connection attributes.

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_Random_Selection 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	TTC_Random_Selection	0 = Client selects the first server specified by the TTC_ServerN attributes. 1 (default)= Initially, the list of failover servers provided by TTC_ServerN connection attributes is randomized. After which, the client selects sequentially from the randomized list for the initial connection and then for any client failover request.
Windows ODBC Data Source Administrator	Not applicable