Idle connection parameter [IDLE]

Specifies the idle timeout period of the connection.

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.

Integer

Value of -ti

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).

• The following connection string fragment sets the timeout value for this connection to 10 minutes:

  "ENG=myeng;LINKS=tcpip;IDLE=10"