ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Detector didn't capture QMF query

book

Article ID: 109713

calendar_today

Updated On:

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

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 .
Powered by Wolken Software