DB2 Version 10.1 for Linux, UNIX, and Windows

CONNECTIONIDLETIME threshold

The CONNECTIONIDLETIME threshold specifies a maximum amount of time that a connection can be idle (that is, not working on a user request).

Type: Connection
Definition domain: Database or service superclass
Enforcement scope: Database
Tracked work: User connections
Queuing: No
Unit: Time duration expressed in minutes, hours, or days
Predictive or reactive: Reactive

If a connection remains idle for longer than the duration specified by the threshold and the threshold action is STOP EXECUTION, the connection is closed.