CONN QUEUE MAX DEPTH field (MAXCONQN subsystem parameter)
If the number of active in-use DBATs has reached the MAXDBAT threshold, the MAXCONQN subsystem parameter specifies the maximum number of inactive or new connection requests that can be queued waiting for a DBAT to process the request.
| Acceptable values: | OFF, ON, 1–19999 |
|---|---|
| Default: | OFF |
| Update: | option 46 on panel DSNTIPB |
| Online changeable: | Yes |
| DSNZPxxx: | DSN6FAC MAXCONQN |
- ON
- The depth of the connection queue is limited by the value of the MAXDBAT subsystem parameter. If the number of queued connection requests exceeds the MAXDBAT value, DDF closes the client connection that has waited the longest in the connection queue.
- OFF
- The depth of the connection queue is limited by the value of the CONDBAT subsystem parameter. OFF is the default value.
- 1–19999
- The maximum number of connections that can be queued waiting for a DBAT to process a request. If the number of queued connection requests exceeds the numeric MAXCONQN value, DDF closes the client connection that has waited the longest in the connection queue.
The closed connections give remote clients an opportunity to redirect the work to other members of the group that have more resources to process the work.
The function is enabled only when the Db2 subsystem is a member of a data sharing group, and Db2 was started with subsystem parameter CMTSTAT set to INACTIVE.