DSNL074I NUMBER OF CLIENT CONNECTIONS HAS EXCEEDED exceeded-percent % OF THE MAXIMUM ALLOWED
Explanation
The number of increasing client connections has exceeded either 80% or 90% relative of the value of the CONDBAT subsystem parameter.
- percent-exceeded
- The percentage of the threshold specified by the value of the CONDBAT subsystem parameter that was exceeded.
The DSNL074I message is issued only when the Db2 subsystem is a member of a data sharing group.
System action
The health value reported to WLM is decreased to 50% (when the value of exceeded-percent is 80) or 25% (when the value of exceeded-percent is 90) of the calculated Db2 system health value. This action might enable remote client systems to direct work to other members which have more resources to process the work.
The modified health value remains until the number of client connections decreases below either the 80% or 90% threshold.
System programmer response
If a subsequent DSNL075I is displayed, no action is required.
Otherwise, investigate why the number of connections has exceeded the threshold set by the CONDBAT subsystem parameter. You can use the DISPLAY LOCATION command to determine which client locations are sending increasing numbers of connections to the Db2 subsystem. If the cause of the increasing connections in normal workload growth, then additional monitoring might be required. If the increasing connections are the result of and exception condition, additional investigation might be required to resolve the problem.