Idle Connection Parameter [IDLE]

The Idle Connection Parameter determines when a connection will time out.

Function

Specifies the idle timeout period of the connection.

Usage

Anywhere except with Tabular Data Stream™ (TDS) and Shared Memory connections. Shared Memory and TDS connections (including jConnect) ignore the Sybase IQ Idle (IDLE) connection parameter.

Values

Integer

Default

Value of -ti

Description

The Idle (IDLE) connection parameter applies only to the current connection. You can have multiple connections on the same server set to different timeout values.

If no connection idle timeout value is set, the idle timeout value is controlled by the setting on the server, which defaults to 4400 minutes when set by start_iq. In case of a conflict between timeout values, the connection timeout value supersedes any server timeout value whether specified or unspecified.

Optionally, the relevant server command line parameters can be included for both Idle and Liveness Timeout (-ti and -tl respectively).

Example

The following connection string fragment sets the timeout value for this connection to 10 minutes:
```
"ENG=myeng;LINKS=tcpip;IDLE=10"
```