CAN DETECTOR IDENTIFY ACTIVE AND INACTIVE THREADS IN A SYSTEM?

Products

• Detector for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS
• Database Management for DB2 for z/OS - Performance Suite

Issue/Introduction

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?

 

 

 

Environment

Release : 20.0

Component :

Resolution

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.