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.
Note: When a CONNECTIONIDLETIME threshold is defined on a service superclass domain, the threshold
will not be enforced until at least one request (for example, an sql statement) has been submitted
over the connection. Workload assignment and service superclass placement for a connection happens
at first request time, not connect time. Until a request has been submitted, a connection will not
be mapped to a workload and service class, so it will not yet have picked up any CONNECTIONIDLETIME
thresholds that are defined on service superclasses. This limitation does not apply to
CONNECTIONIDLETIME thresholds that are defined on the database domain.