Why has the SQL Data Sharing Group error count decreased during the current interval for CA Detector?
book
Article ID: 112486
calendar_today
Updated On:
Products
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer for DB2 for z/OS
Issue/Introduction
This document states why the SQL Data Sharing Group error count may decrease during a current interval for CA Detector.
Why has the SQL Data Sharing Group error count decreased during the current interval for CA Detector?
Environment
z/OS 1.11 and above.
Resolution
When a collection is stopped for one of the data sharing group members, it's metrics are subtracted from the current interval's group metrics. The first example below shows the metrics for a 2 member Datasharing collection (Group DSNDBG):
Group name ==> DSNDBG Members ==> 4 Selected ==> 2 View Type ==> E A -Activity * -Error View History ==> _ View By ==> C * -SQLcode G -Program U -User L -List
Interval time ==> 01:00 Interval elapsed ==> 36:48.64 ------------------------------------------------------------------------------- U -View Users G -View Programs L -View List M -Member Activity
Group name ==> DSNDBG Members ==> 4 Selected ==> 1 View Type ==> E A -Activity * -Error View History ==> _ View By ==> C * -SQLcode G -Program U -User L -List
Interval time ==> 01:00 Interval elapsed ==> 40:09.48 ------------------------------------------------------------------------------- U -View Users G -View Programs L -View List M -Member Activity