ASA Database Administration Guide
  Connection and Communication Parameters
    Connection parameters

Idle connection parameter [IDLE]

Function 

To specify the connection's idle timeout period.

Usage 

Anywhere except with TDS and Shared Memory connections. Shared Memory and TDS connections (including jConnect) ignore the Adaptive Server Anywhere Idle (IDLE) connection parameter.

Values 

Integer

Default 

240

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 240 minutes. In case of a conflict between timeout values, the connection timeout value supercedes any server timeout value whether specified or unspecified.

Optionally, the relevant server command line parameters could 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"

See also 

-ti server option