CONNECT_TIMEOUT configuration parameter

Use the CONNECT_TIMEOUT configuration parameter to specify the number of seconds that the CONNECT statement attempts to establish a connection to a database server.

onconfig.std value
CONNECT_TIMEOUT 60
values
Positive integers
units
Seconds
takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Usage

To set the optimal value for the CONNECT_TIMEOUT configuration parameter, take into account the total distance between nodes, the hardware speed, the volume of traffic, and the concurrency level of the network.

The CONNECT_TIMEOUT value is divided by the CONNECT_RETRIES value to determine the number of seconds between connection attempts. If you set the CONNECT_TIMEOUT configuration parameter to zero, the database server uses the default value of 60 seconds.

To override the value of the CONNECT_TIMEOUT configuration parameter for the current session, you can set either the CONNECT_TIMEOUT environment option of the SET ENVIRONMENT statement or the client's CONNECT_TIMEOUT environment variable.