CONNECT_RETRIES configuration parameter

Use the CONNECT_RETRIES configuration parameter to specify the maximum number of connection attempts that can be made to each database server after the initial connection attempt fails. These attempts are made within the time limit that the CONNECT_TIMEOUT configuration parameter specifies.

onconfig.std value
CONNECT_RETRIES 1
values
Positive integers
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

The CONNECT_TIMEOUT setting takes precedence over the CONNECT_RETRIES setting. Connection attempts can end after the CONNECT_TIMEOUT value is exceeded, but before the CONNECT_RETRIES value is reached.

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