Setting limits for the queuing of client connections waiting for database access threads

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.