Client General Connection Attributes

Used only when you are connecting to a TimesTen server from a TimesTen client application.

In addition to the attributes detailed in this section, some database attributes and general connection attributes are also available for client connections or impact the behavior of the connection. These attributes are:

To view the value of a client attribute:

The client general connection attributes are described in detail next.

CipherSuites

The CipherSuites attribute lists the cipher suite or suites that can be used, depending also on the client setting.

Specify one or more of the following cipher suites, separated by a comma, and in order of preference:
  • SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256
  • SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384
  • SSL_RSA_WITH_AES_128_CBC_SHA256
There is no default setting.

You must set this attribute for both the client and the server. For TLS to be used, the server and client settings must include at least one common suite.

See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.

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 TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set CipherSuites 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

CipherSuites

Specify SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384, or both, comma-separated and in order of preference

Windows ODBC Data Source Administrator

CipherSuites field on the Oracle TimesTen Client DSN Setup dialog.

Specify SSL_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256, SSL_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384, or both, comma-separated and in order of preference

ChildServer

Identify the child server process with the ChildServer connection attribute.

In a client/server environment, TimesTen can have multiple TimesTen child server processes to handle incoming requests from clients. You provide the ChildServer connection attribute to identify a specific child server process for certain cache connection pool built-in procedures.

Each child server process is identified by a number assigned with the ChildServer=n connection attribute, where n is a number ranging from 1 to the number of running child server processes. Once connected to the child server process, you can execute either the ttCacheConnPoolGet('current') or ttCacheConnPoolApply built-in procedures that are meant for a specific child server process.

For example, the following connects to the child server process identified as 1 and applies the saved cache connection pool configuration to this child server process. It does the same process for child server process 2 (given that ServersPerDSN=2).

Command> connect "DSN=cache1;ChildServer=1;"; 
Command> call ttCacheConnPoolApply; 
Command> disconnect; 

Command> connect "DSN=cache1;ChildServer=2;"; 
Command> call ttCacheConnPoolApply; 
Command> disconnect; 

To learn more about the ClientServer connection attribute, see Managing a Cache Connection Pool to the Oracle Database for Dynamic Load Requests in the Oracle TimesTen In-Memory Database Cache Guide.

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 TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set ChildServer 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

ChildServer

ChildServer=n, where n is a number ranging from 1 to the number of running child server processes.

When you specify the ChildServer connection attribute your client process connects using the identified child server process. If the attribute is not specified, then the client process connects using a randomly selected child server process.

Windows ODBC Data Source Administrator

Not applicable

Encryption

The Encryption attribute specifies whether encryption is accepted, rejected, requested, or required for a client/server connection.

You must set this attribute for both the client and the server. Cipher settings must be the same on both the client and server, in most cases.

See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.

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 TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set Encryption 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

Encryption

  • accepted: Enable an encrypted session if required or requested by the client; use an unencrypted session otherwise. (default)

  • rejected: Demand an unencrypted session. (If the server does not support encryption, TimesTen behaves as if this is the setting on the server.) The connection is rejected if the client requires encryption.

  • requested: Request an encrypted session if the client allows it (if the client has any setting other than rejected); use an unencrypted session otherwise.

  • required: Demand an encrypted session. Reject the connection if the client rejects encryption.

Windows ODBC Data Source Administrator

Encryption field on the Oracle TimesTen Client DSN Setup dialog.

  • accepted: Enable an encrypted session if required or requested by the client; use an unencrypted session otherwise. (default)

  • rejected: Demand an unencrypted session. (If the server does not support encryption, TimesTen behaves as if this is the setting on the server.) The connection is rejected if the client requires encryption.

  • requested: Request an encrypted session if the client allows it (if the client has any setting other than rejected); use an unencrypted session otherwise.

  • required: Demand an encrypted session. Reject the connection if the client rejects encryption.

SSLClientAuthentication

The SSLClientAuthentication attribute specifies whether SSL client authentication is required (setting of 1) or not (setting of 0, the default). With client authentication, the server validates an identity presented by the client, and requires an identity (public/private key) in the client wallet.

Regardless of the client authentication setting, server authentication is performed, where the client validates the server.

You must set this attribute for both the client and the server. Regardless of the client authentication setting, server authentication is performed, where the client validates the server.

See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.

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 TimesTen Classic but not supported in TimesTen Scaleout.

Setting

Set SSLClientAuthentication 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

SSLClientAuthentication

1 - Client authentication is required

0 - No authentication is required. (the default)

Windows ODBC Data Source Administrator

SSL Client Authentication field on the Oracle TimesTen Client DSN Setup dialog.

1 - Client authentication is required

0 - No authentication is required. (the default)

TCP_Port

When connecting to a TimesTen database using the TimesTen client and server, the TimesTen client requires the network address and the TCP port number of the computer running the TimesTen server.

The default TCP/IP port number is assumed for TCP_Port unless you specify a value in the TTC_Server connection attribute, in the ODBC connection string, or in the logical server definition. See TTC_Server or TTC_Server1 for more details.

If the TimesTen server is listening on a non-default port number, you must provide the port number in one of the following ways:

  • If using TimesTen Classic, you can specify the port number within the logical server definition, which contains the network address and port number pair. See Defining a Logical Server Name in Oracle TimesTen In-Memory Database Operations Guide for more information on defining a logical server.

  • You can specify the port number within the TTC_Server connection attribute using:

    TTC_SERVER=server_host_name/server_port;
    
  • You can specify the port number in the ODBC connection string.

    "TTC_SERVER=server_host_name;TTC_SERVER_DSN=Server_DSN;
    TCP_PORT=server_port"
    

    Or:

    "DSN=Client_DSN;TCP_Port=server_port"

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 TCP_Port as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs

TCP_Port

Specify the port number where the server is listening.

Windows ODBC Data Source Administrator and UNIX and Linux systems ttconnect.ini file. See Creating and Configuring a Logical Server Name on Linux and UNIX in Oracle TimesTen In-Memory Database Operations Guide for more details.

TCP_Port on the Oracle TimesTen Logical Server Name Setup dialog.

Specify the port number where the server is listening.

TCP_Port2, TCP_PortN

For TimesTen Classic, TimesTen uses this attribute to specify the port number to use if an automatic failover occurs. (This is unnecessary for TimesTen Scaleout.) See the description of TCP_Port for details on setting the value of this attribute and associated attributes.

The default TCP/IP port number is assumed for TCP_Port2 and TCP_PortN unless you specify a value in the appropriate TTC_ServerN connection attribute, in the ODBC connection string, or in the logical server definition. See TTC_Server or TTC_Server1 for more details.

Unspecified values for TCP_PortN inherit the value of TCP_PORT (or TCP_PORT1). 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 TCP_Port2, TCP_PortN as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs

TCP_Port2, TCP_PortN

Specify the failover port number where the server should listen.

Windows ODBC Data Source Administrator and UNIX and Linux systems ttconnect.ini file. See Creating and Configuring a Logical Server Name on Linux and UNIX in Oracle TimesTen In-Memory Database Operations Guide for more details.

Specify TCP_Port2, TCP_PortN in a connection string when also specifying a TTC_Server2, TTC_ServerN.

Specify the failover port number where the server should listen.

TTC_ConnectTimeout

The TTC_ConnectTimeout attribute specifies the maximum number of seconds the client waits for a SQLDriverConnect or SQLDisconnect request. It overrides the value of TTC_Timeout for those requests. Set the TTC_ConnectTimeout when you want connection requests to timeout with a different timeframe than the timeout provided for query requests. For example, you can set a longer timeout for connections if you know that it takes a longer time to connect, but set a shorter timeout for all other queries.

(You can use TTC_SqlTimeoutMS to override TTC_Timeout for all other requests, at a millisecond level.)

A value of 0 means there is no timeout. A negative value defers to the TTC_Timeout setting. As with TTC_Timeout, if the timeout is reached, the connection and the associated socket are closed without a call to SQLDisconnect.

TTC_ConnectTimeout can be set in either the client connection string or the client DSN.

For more details, see Choose SQL and PL/SQL Timeout Values in the Oracle TimesTen In-Memory Database Operations Guide.

Also see TTC_Timeout and TTC_SqlTimeoutMS.

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_ConnectTimeout 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_ConnectTimeout

Seconds to wait for a client connect or disconnect request. Default is 20 seconds.

Windows ODBC Data Source Administrator

Not applicable

TTC_FailoverPortRange

Specifies a port range for the port that the automatic client failover thread listens on for failover notifications in an active/standby replication configuration. The failover configuration enables a client application to connect to a new active node automatically if there is a failure on the current node.

Specifying a port range helps accommodate firewalls between the client and server systems. By default, TimesTen uses a port chosen by the operating system.

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_FailoverPortRange 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_FailoverPortRange

Specify a lower value and an upper value for the port numbers in the format lowervalueuppervalue.

Windows ODBC Data Source Administrator

Failover Port Range field on the Oracle TimesTen Client DSN Setup dialog.

Specify a lower value and an upper value for the port numbers in the format lowervalueuppervalue.

TTC_NetMsgMaxBytes

The TTC_NetMsgMaxBytes attribute specifies the maximum size in bytes of a client result set buffer.

The server stores a maximum number of bytes in the result set buffer size returned from a SELECT statement. To improve the application’s performance, you can increase or decrease the maximum size in bytes of a client result set buffer with the TTC_NetMsgMaxBytes connection attribute.

The buffer size can be set in terms of bytes or rows. The lower limit takes precedence. If you set one of them, it is recommended that you set the other also. It is suggested to decide first which maximum attribute you want to use and set it; then, set the other attribute to a value high enough to ensure that this value is not reached first.

The SELECT statement will always return a complete result set even if filling the buffer takes multiple iterations. The SELECT result is not limited by the TTC_NetMsgMaxBytes attribute.

You can set the TTC_NetMsgMaxBytes attribute in a connection string or DSN to serve as the value for any SELECT statement on the connection.

Note:

Although the minimum possible setting value for the TTC_NetMsgMaxBytes attribute is one byte, using this value would result in a buffer that is too small to contain the smallest row. For this reason, regardless of the value specified, the buffer is always sized to be large enough to contain at least one row.

See Sizing the Client Result Set Buffer in the Oracle TimesTen In-Memory Database Operations Guide for more information.

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_NetMsgMaxBytes 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_NetMsgMaxBytes

A positive integer value. The minimum size is 1. Default is 2097152 bytes (2MB).

Windows ODBC Data Source Administrator

Net Msg Max Bytes field on the Oracle TimesTen Client DSN Setup dialog.

A positive integer value. The minimum size is 1. Default is 2097152 bytes (2MB).

TTC_NetMsgMaxRows

The TTC_NetMsgMaxRows attribute specifies the maximum number of rows stored in the client result set buffer.

Notes

The server stores a maximum number of rows in the result set buffer size returned from a SELECT statement. To improve the application’s performance, you can increase or decrease the maximum number of rows of a client result set buffer with the TTC_NetMsgMaxRows connection attribute.

  • The SELECT statement will always return a complete result set even if filling the buffer takes multiple iterations. The SELECT result is not limited by the TTC_NetMsgMaxRows attribute.
  • The buffer size can be set in terms of rows or bytes. The lower limit takes precedence. If you set one of them, it is recommended that you set the other also. It is suggested to decide first which maximum attribute you want to use and set it; then, set the other attribute to a value high enough to ensure that this value is not reached first.

You can set the TTC_NetMsgMaxRows attribute in a connection string or DSN to serve as the value for any SELECT statement on the connection.

See Sizing the Client Result Set Buffer in Oracle TimesTen In-Memory Database Operations Guide for more information.

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_NetMsgMaxRows 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_NetMsgMaxRows

A positive integer value. The minimum is 1 row. Default is 8192 rows.

Windows ODBC Data Source Administrator

Net Msg Max Rows field on the Oracle TimesTen Client DSN Setup dialog.

A positive integer value. The minimum is 1 row. Default is 8192 rows.

TTC_NoReconnectOnFailover

Specifies whether the TimesTen client should not automatically reconnect to the server after a failover. If this is set to 1 (enabled), TimesTen is instructed to do all the usual client failover processing except for the reconnect. (For example, statement and connection handles are marked as invalid.) This is useful if the application does its own connection pooling or manages its own reconnection to the database after failover. The default value is 0 (reconnect).

You must configure automatic client failover for this option. See Client Connection Failover in Oracle TimesTen In-Memory Database Scaleout User's Guide for more information.

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_NoReconnectOnFailover 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_NoReconnectOnFailover

0 = Client reconnects to server after failover (default).

1 = Client does all the failover processing, but does not reconnect after failover.

Windows ODBC Data Source Administrator

No reconnect on failover field on the Oracle TimesTen Client DSN Setup dialog.

0 = Client reconnects to server after failover (default).

1 = Client does all the failover processing, but does not reconnect after failover.

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

TTC_REDIRECT

For TimesTen Scaleout, TTC_REDIRECT defines how a client is redirected. If this is set to 0 and the initial connection attempt to the desired data instance fails, then an error is returned and there are no further connection attempts. This does not affect subsequent failovers on that connection.

Automatic redirection: By default, this connection attribute is set to 1 so that a client connection is automatically redirected to any available data instance within the grid if the current host is busy or unavailable. The connection is redirected to the host with the fewest number of client connections.

Elements within a single replica set: If you want the client to connect to elements within a single replica set (because the data you are interested in is contained within this replica set), then set the TTC_REDIRECT connection attribute to 0. Then, the client connects only to the host indicated by the DSN or to the host with the element in the same replica set. If the connection is rejected, then a connection error is returned.

The TTC_Redirect_Limit attribute limits how many times the client is redirected. The number of hosts in your grid can be of a size that you want to limit the number of redirected client connection attempts for performance reasons. You can set the TTC_Redirect_Limit connection attribute to the number of connection redirection attempts. For example, setting TTC_Redirect_Limit=10 limits the number of client connection redirection attempts to other hosts to 10 attempts. If the client does not connect within this number of attempts, a connection error is returned.

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_REDIRECT 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_REDIRECT

1 (default) - redirect to any available data instance

0 - error if redirection to specified data instance fails

Windows ODBC Data Source Administrator

Not applicable

TTC_Redirect_Limit

For TimesTen Scaleout, TTC_Redirect_Limit limits how many times the client is redirected.

This is useful if the number of hosts in your grid is such that you want to limit the number of redirected client connection attempts for performance reasons.

For example, setting TTC_Redirect_Limit=10 limits the number of client connection redirection attempts to other hosts to 10 attempts. If the client does not connect within this number of attempts, a connection error is returned.

Note:

There is no setting for no limit, but you can set it to a very large integer.

Required Privilege

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

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is not supported in TimesTen Classic.

This attribute is supported in TimesTen Scaleout.

Setting

Set TTC_Redirect_Limit as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems database definition (.dbdef) file in TimesTen Scaleout

TTC_Redirect_Limit

Integer to limit how many times the client is redirected. The default is 1.

Windows ODBC Data Source Administrator

Not applicable

 

TTC_Server or TTC_Server1

When connecting to a TimesTen database using the TimesTen client and server, the TimesTen client requires the specification of the network address and TCP port number of the computer running the TimesTen server. The network address provided can be a domain name server (DNS), host name or IP address.

Note:

If you are configuring for client failover, you may define more than one TimesTen server. See TTC_Server2, TTC_ServerN for more information.

If the TimesTen server is listening on a non-default port number, you must provide the port number in one of the following ways:

  • You can specify the port number within the TTC_Server connection attribute using:

    TTC_SERVER=server_host_name/server_port;
    
  • You can specify the port number in the ODBC connection string.

    "TTC_SERVER=server_host_name;TTC_SERVER_DSN=Server_DSN;
    TCP_PORT=server_port"
    

    Or:

    "DSN=Client_DSN;TCP_Port=server_port"
    
  • If using TimesTen Classic, you can specify the port number within the logical server definition in the ttconnect.ini file.

See TCP_Port for more details.

Note that:

  • You can use either TTC_Server or TTC_Server1 for TimesTen Scaleout. If you define the TTC_Server connection attribute, the value is used only for the initial connection.

  • You can specify a logical server name for the TTC_Server attribute with TimesTen Classic that contains the network address and port number pair in the ttconnect.ini file. Once the logical server name is defined in the ttconnect.ini file, you can use that name as the value for the TTC_Server attribute in a Client DSN definition. Multiple Client DSNs referencing the same computer that is running the TimesTen server can use the same logical server name for the value of the TTC_Server attribute instead of having to specify repeatedly the same network address and port number within each of the Client DSNs. See Creating and Configuring a Logical Server Name on Linux and UNIX in the Oracle TimesTen In-Memory Database Operations Guide for more details.

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 or TTC_Server1 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_Server, TTC_Server1

Character string specifying the logical server.

Windows ODBC Data Source Administrator

Server Name or Network Address field on the Oracle TimesTen Client DSN Setup dialog.

Character string specifying the logical server.

TTC_Server2, TTC_ServerN

For TimesTen Classic, this attribute specifies the logical server name to use if an automatic failover occurs. See the description of TTC_Server or TTC_Server1 for details on setting the value of this attribute and associated attributes.

  • When using automatic client failover with an active standby pair replication scheme in TimesTen Classic, you can only define TTC_Server2. After which, the client alternately attempts to connect to TTC_Server and TTC_Server2 until a connection succeeds or the TTC_TIMEOUT attribute expires.

  • For other types of automatic client failover, you can specify a list of failover servers with TTC_ServerN connection attributes where N >= 2. TimesTen can iterate through this list of designated failover servers (as necessary) that you configured as TTC_Server2, TTC_Server3, TTC_Server4, and so on. The maximum number of servers that the client can specify is 999.

    Note:

    See TTC_Random_Selection on how TimesTen iterates through the list of designated failover servers.

Unspecified values for TTC_ServerN, TTC_Server_DSNN, and TCP_PortN inherit the value of TTC_Server (or equivalently, TTC_Server1), TTC_Server_DSN (or TTC_Server_DSN1), and TCP_PORT (or TCP_PORT1), respectively. 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.

You should configure your failover servers sequentially. If you do skip a number when configuring your failover servers, then TimesTen automatically creates the missing definition and assigns it to the server identified by TTC_Server. In this case, your client could fail over to the same server multiple times.

When using an active standby pair replication scheme for client failover, the TTC_Server or TTC_Server1 and TTC_Server2 connection attributes could potentially have the same setting if it is a virtual IP address. Virtual IP addresses can dynamically move to different hosts; thus, both connection attributes may have the same definition, but could be referencing distinct databases.

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 attributes.

Usage in TimesTen Scaleout and TimesTen Classic

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

Setting

Set TTC_Server2 or TTC_ServerN 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_Server2, TTC_ServerN

Character string specifying the logical server to be used if an automatic failover occurs.

Windows ODBC Data Source Administrator

Failover Server Name or Network Address field on the Oracle TimesTen Client DSN Setup dialog configures the TTC_Server2 connection attribute.

Character string specifying the logical server to be used if an automatic failover occurs.

TTC_Server_DSN

The TTC_Server_DSN attribute specifies a Server DSN on the computer running the TimesTen server.

More details on this topic can be found in Creating Client DSNs on a TimesTen Client System in the Oracle TimesTen In-Memory Database Operations Guide.

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_DSN 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_Server_DSN

Character string specifying the DSN that resides on the server.

Windows ODBC Data Source Administrator

Server DSN field on the Oracle TimesTen Client DSN Setup dialog.

Character string specifying the DSN that resides on the server.

TTC_Server_DSN2, TTC_Server_DSNn

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.

TTC_SqlTimeoutMS

For client/server, this specifies the integer number of milliseconds the client will wait for a response to a request. It overrides the TTC_Timeout connection attribute for any SQL execution request other than SQLDriverConnect or SQLDisconnect. A value of 0 means there is no timeout. A negative value defers to the TTC_Timeout setting (which is in integer seconds).

(The timeout for SQLDriverConnect and SQLDisconnect is specified by setting the TimesTen TTC_ConnectTimeout connection attribute.)

Also see TTC_Timeout and TTC_ConnectTimeout.

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_SqlTimeoutMS 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_SqlTimeoutMS

Integer milliseconds to wait for response from client.

Windows ODBC Data Source Administrator

N/A

TTC_TCP_KEEPALIVE_INTVL_MS

The TTC_TCP_KEEPALIVE_INTVL_MS attribute sets the time interval (in milliseconds) between subsequential probes.

By default, if the connection fails, TimesTen Scaleout sends the client connection to another active server. Part of the method to see if the connection is up or if it has failed is to check the TCP socket. When a TCP connection is started, a set of timers are associated with the connection. These timers indicate when TimesTen Scaleout checks the TCP socket to determine whether the connection is up or if it has failed.

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_TCP_KEEPALIVE_INTVL_MS 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_TCP_KEEPALIVE_INTVL_MS

A positive integer value. Default is 1000.

Windows ODBC Data Source Administrator

TCP KeepAlive Interval field on the Oracle TimesTen Client DSN Setup dialog.

A positive integer value. Default is 1000.

TTC_TCP_KEEPALIVE_PROBES

The TTC_TCP_KEEPALIVE_PROBES attribute sets the number of unacknowledged probes to send before considering the connection as failed and notifying the client.

By default, if the connection fails, TimesTen Scaleout sends the client connection to another active server. Part of the method to see if the connection is up or if it has failed is to check the TCP socket. When a TCP connection is started, a set of timers are associated with the connection. These timers indicate when TimesTen Scaleout checks the TCP socket to determine whether the connection is up or if it has failed.

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_TCP_KEEPALIVE_PROBES 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_TCP_KEEPALIVE_PROBES

A positive integer value. Default is 2.

Windows ODBC Data Source Administrator

TCP KeepAlive Probes field on the Oracle TimesTen Client DSN Setup dialog.

A positive integer value. Default is 2.

TTC_TCP_KEEPALIVE_TIME_MS

The TTC_TCP_KEEPALIVE_TIME_MS attribute sets the duration time (in milliseconds) between the last data packet sent and the first probe.

By default, if the connection fails, TimesTen Scaleout sends the client connection to another active server. Part of the method to see if the connection is up or if it has failed is to check the TCP socket. When a TCP connection is started, a set of timers are associated with the connection. These timers indicate when TimesTen Scaleout checks the TCP socket to determine whether the connection is up or if it has failed.

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_TCP_KEEPALIVE_TIME_MS 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_TCP_KEEPALIVE_TIME_MS

A positive integer value. Default is 1000.

Windows ODBC Data Source Administrator

TCP KeepAlive Time field on the Oracle TimesTen Client DSN Setup dialog.

A positive integer value. Default is 1000.

TTC_Timeout

The TTC_Timeout attribute sets a maximum time limit, in seconds, for a network operation that is completed by using the TimesTen client and server. The TTC_Timeout attribute also determines the maximum number of seconds a TimesTen client application waits for the result from the corresponding TimesTen server process before timing out. For example, if the Client application is running long queries, you may want to increase the timeout interval.

The operating systemselect() call on the client side of a client/server connection uses the value of TTC_Timeout. The SQLExecute() and OCIStmtExecute() functions do not.

A value of 0 indicates that client/server operations should not timeout. If this attribute is not set, the default timeout period is 60 seconds. The maximum timeout period is 99,999 seconds. Upon timeout, the operation is interrupted, the Client application receives a timeout error and the connection is terminated and socket closed (without a call to SQLDisconnect).

For active standby pair failover scenarios, the minimum value is 60 seconds.

The timeout value can be set after establishing a connection by calling the ttIsql clienttimeout command. When the query timeout is set after establishing a connection to the database, the client driver returns an error if the network timeout value is greater than 0, and the query timeout value greater than or equal to the network timeout value. The SQLState is set to S1000.

This attribute is not supported (the setting ignored) when shared memory is used for client/server inter-process communication.

See Choose SQL and PL/SQL Timeout Values in Oracle TimesTen In-Memory Database Operations Guide for information about the relationship between TTC_Timeout, SQLQueryTimeout, and PLSQL_TIMEOUT.

TTC_Timeout can be overridden for connect and disconnect requests by TTC_ConnectTimeout and for all other SQL execution requests by TTC_SqlTimeoutMS (at millisecond level). See TTC_ConnectTimeout and TTC_SqlTimeoutMS.

The SQLQueryTimeout/SQLQueryTimeoutMsec value should be less than the TransactionTimeout value; the TransactionTimeout value should be less than the TTC_Timeout value.

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_Timeout 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_Timeout

A value between 0 and 99999 that represents the number of seconds that the TimesTen client waits for an operation to complete before timing out. (The default value is 60.) In an active standby pair failover scenario, the minimum value is 60.

Windows ODBC Data Source Administrator

Network Timeout field on the Oracle TimesTen Client DSN Setup dialog.

A value between 0 and 99999 that represents the number of seconds that the TimesTen client waits for an operation to complete before timing out. (The default value is 60.) In an active standby pair failover scenario, the minimum value is 60.

Wallet

The Wallet attribute specifies the fully qualified directory path name, where you placed the certificates that you generated (preferably the same directory path as on the client). There is no default location. If you specify a relative path, it is relative to the timesten_home/info directory.

You must set this attribute for both the client and the server. You must set the same path on both the client and server.

See Configuration for TLS for Client/Server in Oracle TimesTen In-Memory Database Security Guide for more details.

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 Wallet 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

Wallet

A fully qualified directory path name (no default).

Windows ODBC Data Source Administrator

Wallet field on the Oracle TimesTen Client DSN Setup dialog.

A fully qualified directory path name (no default).