CONN QUEUE MAX WAIT field (MAXCONQW subsystem parameter)

The MAXCONQW subsystem parameter specifies the maximum length of time that a client connection waits for a DBAT to process the next unit-of-work or new connection request.

Acceptable values: ON, OFF, 5 - 3600 seconds
Default: Start of changeONEnd of change
Update: option 46 on panel DSNTIPB
DSNZPxxx: DSN6FAC MAXCONQW
ON
Connections wait as long as the value specified by the IDTHTOIN subsystem parameter.
OFF
Connections wait indefinitely for a DBAT to process requests.
Numeric value
The time duration in seconds that a connection waits for a DBAT to process the request.

Each queued connection request entry is examined to see if its time waiting in the queue has exceeded the specified value. If the time is exceeded, the client connection is closed.

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.

This subsystem parameter can be updated online.