Idle Connection Parameter [IDLE]

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 SAP 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 that are 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).

See Also

-ti iqsrv16 server option in Utility Guide > start_iq Database Server Startup Utility.

Example

This connection string fragment sets the timeout value for this connection to 10 minutes:

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