Programmer Guide : Timeout controls : HotStandby timeouts
  
HotStandby timeouts
Timeouts related to the HotStandby server are described in this topic.
Connect timeout
By specifying a connect timeout value with the HotStandby.ConnectTimeout parameter, you can set the maximum time in milliseconds that a HotStandby connect operation waits for a connection to a remote machine. The HotStandby.ConnectTimeout parameter is only used with the following subset of ADMIN COMMANDs:
hotstandby connect hotstandby switch primary hotstandby switch secondary
INI parameter
Overridden with SQL
Driver
Connection string
[HotStandby] ConnectTimeout=milliseconds
 
 
 
Ping timeout
The HotStandby.PingTimeout parameter specifies in milliseconds how long a server waits before concluding that the other server is down or inaccessible.
INI parameter
Overridden with SQL
Driver
Connection string
[HotStandby] PingTimeout=milliseconds
 
 
 
Transparent connection timeout
The client-side TransparentFailover.ReconnectTimeout parameter specifies how long (in milliseconds) the driver should wait until it tries to reconnect to the primary in case of TF switchover or failover.
The client-side TransparentFailover.WaitTimeout parameter specifies how long (in milliseconds) the driver should wait for the server to switch state.
INI parameter
Overridden with SQL
Driver
Connection string
[TransparentFailover] ReconnectTimeout=milliseconds
 
ODBC:
SQL_ATTR_TF_RECONNECT_TIMEOUT
JDBC:
solid_tf1_reconnect_timeout
 
[TransparentFailover] WaitTimeout=milliseconds
 
ODBC:
SQL_ATTR_TF_WAIT_TIMEOUT
JDBC:
solid_tf_wait_timeout
 
See also
Timeout controls