Detector didn't capture QMF query

Article Id: 109713

Status: Published

Updated On: 07-08-2018 15:38

Products:

CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Database Detector for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction:

QMF for windows timed out on him. It appears the thread didn’t get cleaned up properly. SMF records summary shows that the query ran for 29 hours(107646 seconds). That query is nowhere to be found in Detector. Why?

Environment:

Release:
Component: PDT

Resolution:

The collection was started with Dyn(N)parm meaning do not collect Dynamic SQL .