INFORMIXCONTIME configuration parameter

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

onconfig.std value
INFORMIXCONTIME 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 INFORMIXCONTIME 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 INFORMIXCONTIME value is divided by the INFORMIXCONRETRY value to determine the number of seconds between connection attempts. If you set the INFORMIXCONTIME configuration parameter to zero, the database server uses the default value of 60 seconds.

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


Copyright© 2019 HCL Technologies Limited