search cancel

Detector not detecting sql errors

book

Article ID: 189939

calendar_today

Updated On:

Products

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

Issue/Introduction

SQL-443 and  SQL-723  don't show up in detector.  Is this expected?

Environment

Release : 20.0

Component : CA Detector for DB2 for z/OS

Resolution

The problem was that there was a data sharing member up that was was running. So the SQL was being ran on that member and there wasn't a Detector data collection running for it. Once  that DB2 member was  shut down, the SQL errors started being captured.