Detector: Exclude SQL error codes by specific plans/application ids
Article ID: 257256
Updated On: 10-19-2023
Products
Database Management for DB2 for z/OS - Administration Suite
Database Management for DB2 for z/OS - Performance Suite
Database Management for DB2 for z/OS - Recovery Suite
Database Management for DB2 for z/OS - SQL Performance Suite
Database Management for DB2 for z/OS - Utilities Suite
Issue/Introduction
Is there a way to exclude SQL errors, but not for all occurrences, but for just specific filtered criteria (E.g., authid = x or plan = y)?
Environment
Release : 20.0
Resolution
There is no flexibility or granularity to limit the exclusion to a certain package/plan. That flexibility exists for collecting data which is controlled by option 1 Collection Profile Plan Exclude/Include Group but not for SQL error.
Feedback
Was this article helpful?
Yes
No
Powered by
