Why has the SQL Data Sharing Group error count decreased during the current interval for CA Detector?

Document ID : KB000112486
Last Modified Date : 03/10/2018
Show Technical Document Details
Introduction:
This document states why the SQL Data Sharing Group error count may decrease during a current interval for CA Detector.
Question:
Why has the SQL Data Sharing Group error count decreased during the current interval for CA Detector?
Environment:
z/OS 1.11 and above.
Answer:
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):

1) 19.0     ----- DETECTOR DS Group SQL Error Summary Display ----- 18/08/29 16:36

   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              
                                                                               
      SQLCODE ERRORCNT MEMBERS   LASTDATE LASTTIME  1STDATE  1STTIME              
      ------- -------- --------  -------- --------  -------- --------             
   _     -501      400        2  18/08/29 16:36:42  18/08/29 16:32:49             
   _     -502      400        2  18/08/29 16:36:42  18/08/29 16:32:49             
   _     -305      404        2  18/08/29 16:36:42  18/08/29 16:32:49     

The 2nd print is taken 4 minutes later, after the collection was stopped for one of the members. Notice the decrease in the Error count:

 2) 19.0     ----- DETECTOR DS Group SQL Error Summary Display ----- 18/08/29 16:40

   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              
                                                                               
      SQLCODE ERRORCNT MEMBERS   LASTDATE LASTTIME  1STDATE  1STTIME              
      ------- -------- --------  -------- --------  -------- --------             
   _     -501      200        1  18/08/29 16:32:49  18/08/29 16:32:49             
   _     -502      200        1  18/08/29 16:32:49  18/08/29 16:32:49             
   _     -305      202        1  18/08/29 16:32:49  18/08/29 16:32:49