SQL Statement Types and Capture Options not working after the update of an exception

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
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

After a change to an application exception or the restart of the exception system the

Capture SQL text to data set option does not work anymore.

To repair this is a recycle of the  data collector is needed.

Environment

Release : 19.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

The sysparm EXCEPTION-INTERVAL=10 setting should be reviewed.

Adjusted the EXCEPTION-INTERVAL to 5 seconds and the elapse between exception checks to 5 and set the value of the thresholds in so that "warning and critical" do not overlap

each other during exception intervals.