Detector: Exclude SQL error codes by specific plans/application ids
search cancel

Detector: Exclude SQL error codes by specific plans/application ids

book

Article ID: 257256

calendar_today

Updated On:

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.