Excessive -DISPLAY GROUP Detail commands being issued by IDB2 Data Collector

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

There is an excessive amount of -Display Group Detail commands populating Messages/DB2 commands
 

Environment

Release : 20.0

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

Cause

In this particular case the excessive Display Group Detail command (DSGRPDTL request) was being generated by two Subsystem Exception Requests.

High percent of SCA in use: &VALUEXX  and  High percent of CF list entries in use: &VALUEXX

Resolution

There are multiple ways that the -display group detail command can be invoked.  The manual way is for an 'end-user' to sit at the DSGRPDTL request screen and hit 'enter'.  However, the volume experienced would not be from that process.  The other way is through the Exception processor where the following two Permanent Exception Definitions(0) Subsytem exceptions(1) are active:
High percent of SCA in use: &VALUEXX  and High percent of CF list entries in use: &VALUEXX
Both of these subsystem exceptions call the DSGRPDTL request.  These exceptions can be inactivated or modified.