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

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

book

Article ID: 140580

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 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.