Idle connection parameter [IDLE]

Function

To specify the idle timeout period of the connection.

Usage

Anywhere except with 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).

See also

-ti server command-line option in Chapter 1, “Running the Database Server” in the Utility Guide

Example