Operating System Settings

You can set the following operating system parameter to prevent your system from closing the connection if the Connect session is not considered active.

Note:

This parameter is supported for the ODBC driver and the latest version of the JDBC driver. For more information, see the following topics:

KeepAliveTime

Description

Optional. This parameter verifies periodically that the idle TCP connections are still active. By default, this parameter is set to 7,200,000 ms (2 hours) and affects all system applications. You can change the settings and enter a lower value. For example, if you set the value to three minutes, the idle TCP connections are verified every three minutes. After this change, if you run a query and you do not receive any results within the next three minutes, the connection is not interrupted. Every three minutes the driver sends a keep-alive packet to keep the connection active. For more information, see Idle Connection Timeout.

Valid Values

Time period in milliseconds. Use your best judgement to decide the time value that you want to use. For example, if you want to use 3 minutes, type 180000.

Default

7,200,000 ms (2 hours)

Data type

String

KeepAliveTime

Related Topics