Detector did not capture QMF query.

Products

• Bind Analyzer for DB2 for z/OS
• SQL-Ease for DB2 for z/OS
• SYSVIEW Performance Management Option for DB2 for z/OS
• Plan Analyzer for DB2 for z/OS
• Subsystem Analyzer for DB2 for z/OS
• Detector for DB2 for z/OS

Issue/Introduction

QMF for windows timed out.  It appears the thread did not get cleaned up properly. SMF records summary shows that the query ran for 29 hours (107646 seconds).
That query could not be located within Detector for Db2 for z/OS. Why?

Environment

Release: 20.0
Component: PDT

Resolution

The Detector collection was started with DYN(N) parameter meaning do not collect Dynamic SQL .