WE'RE LOOKING FOR A MECHANISM IN SYSVIEW/DB2 TO WARN US WHEN PERCENTAGE OF MAXDBAT IS REACHED, OMEGAMON HAS ONE:
PK78018: KDP_MDBT_CRITICAL/WARNING SITUATION DESC NEEDS CORRECTION
KDP_MDBT_CRITICAL/WARNING situation in TEP has been changed to
trigger on number of DBAT approaching maximum from dsnzparm.
So, when the number of Database Active Threads is greater than a
threshold defined by the customer in TEP, the situation will
fire. The threshold is a percentage of MAXDBAT. For example
if MAXDBAT = 100 and the threshold is 80%, then 80 or more DBAT
threads will cause an alert to be generated.
Release : 20.0
Component : CA SYSVIEW Performance Management Option for DB2 for z/OS
If you select option 0 Permanent Exception Definitions and then 1 Subsystem Exceptions.
Then Use F6 to add, then any of the first 7 options will give you the following: Exception Field Variables
Select field 1 using an "S". Then press Enter. DB2/IDB2 Field. Queued client conn TCPIP sockets closed - MAXDBAT QDSTNCQC