The Maximum DDF remote connection threshold is being exceeded. Omegamon for Db2 is showing a High Water Mark(HWM) of 6044 for remote connections but there is no message in DB2 MST related to this. Is there a way using Detector(PDT) or Subsystem Analyzer(PSA) to show all the threads that are active and inactive when the CONDBAT limit is exceeded or track which threads are driving the increase in DDF usage?
Release : 20.0
PDT/SSA(Detector/Subsystem Analyzer) is SQL based not Thread based. PDT/PSA don't have any feature for this. Sysview For DB2(IDB2) is a thread based product and has the features to identify active/Inactive threads in the system.