Detector did not capture QMF query Dyanmic SQL activity
search cancel

Detector did not capture QMF query Dyanmic SQL activity

book

Article ID: 109713

calendar_today

Updated On:

Products

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 (PDT). Why?

Resolution

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