INFORMIXCONRETRY environment variable

The INFORMIXCONRETRY environment variable sets a limit on the maximum number of connection attempts that can be made to each database server by the client after the initial connection attempt fails. These attempts are made within the time limit that the INFORMIXCONTIME setting specifies.

Read syntax diagramSkip visual syntax diagram

The number of additional attempts to connect to each database server after the initial connection attempt fails.
For example, the following command sets INFORMIXCONRETRY to specify three connection attempts after the initial attempt:

The default value for INFORMIXCONRETRY is one attempt after the initial connection attempt.

Order of precedence among INFORMIXCONRETRY settings

When you specify a setting for the INFORMIXCONRETRY client environment variable, it overrides any INFORMIXCONRETRY configuration parameter setting in the onconfig file.

If the SET ENVIRONMENT statement specifies a setting for the INFORMIXCONRETRY session environment option, however, the SQL statement setting overrides the INFORMIXCONRETRY client environment variable setting for subsequent connection attempts during the current session. The SET ENVIRONMENT INFORMIXCONRETRY setting has no effect on other sessions.

In summary, this is the ascending order (lowest to highest) of the methods for setting a limit on attempts for a connection to a database server:

  • INFORMIXCONRETRY configuration parameter
  • INFORMIXCONRETRY client environment variable

The INFORMIXCONTIME setting takes precedence over the INFORMIXCONRETRY setting. Connection attempts can end after the INFORMIXCONTIME value is exceeded, but before the INFORMIXCONRETRY value is reached. For more information about restricting the time available to establish a connection to a database server, see INFORMIXCONTIME environment variable

Copyright© 2018 HCL Technologies Limited