You can establish limits for the depth of the client connection
queue and the time that client connections wait for database access
threads (DBATs).
Before you begin
This function is supported only when the Db2 subsystem is a member of a data sharing group.
About this task
You can specify thresholds to control the queuing of
connections waiting for DBATs. When the thresholds are reached, some
connections are closed. The closing of connections provides opportunities
for remote client systems to redirect work to other members of the
data sharing group that have more resources.
Procedure
To control queuing for client connections, use the
following approaches:
- Specify the value of the MAXCONQN subsystem parameter to
control the maximum number of connections in the queue waiting for
a DBAT. You can apply either of the following choices:
- Set the value to ON to limit the number of queued connections
to the value of the MAXDBAT subsystem parameter.
- Specify a numeric value to indicate the threshold for the
number of queued connections. The value that you specify must be less
than or equal to the maximum supported value for the MAXDBAT subsystem
parameter.
- Specify the value of the MAXCONQW subsystem parameter to
control the maximum time that connections wait for DBATs. You can
apply either of the following choices:
- Set the value to ON to limit the amount of time that queued
connections wait for DBATs to the value of the IDTHTOIN subsystem parameter.
- Specify a numeric value to limit the amount of time (in seconds)
that queued connections wait for DBATs. You can specify a value equal
to or greater than 5 seconds and less than or equal to 3600 seconds.