MAXCONQN in macro DSN6FAC
The MAXCONQN subsystem parameter specifies the maximum number of inactive or new connections that can be queued waiting for a DBAT to process the request.
| Acceptable values: | OFF, ON, 1 to 19999 |
| Default: | OFF |
| DSNZPxxx: | DSN6FAC MAXCONQN |
- OFF
- The depth of the connection queue is limited by the value of the CONDBAT subsystem parameter. The default value is OFF.
- ON
- The depth of the connection queue is limited by the value of the MAXDBAT subsystem parameter.
- Numeric value
- The maximum number of connections that can be queued waiting for a DBAT to process a request.
When a request is added to the connection request queue and the thresholds specified by both the MAXDBAT and MAXCONQN subsystem parameters are both reached (unless MAXCONQN is set to OFF) then DDF closes the client connection longest waiting client connection in the 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 DB2® subsystem is a member of a data sharing group.
This subsystem parameter can be updated online.
