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

Products

• Detector for DB2 for z/OS

Issue/Introduction

Why has the SQL Data Sharing Group error count decreased during the current interval for Detector for Db2 for z/OS (PDT).

Resolution

When a PDT collection is stopped for one of the data sharing group members, it's metrics are subtracted from the current interval group metrics.
The first example below shows the metrics for a 2 member data sharing collection (Group <group>):


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

   Group name ==> <group>       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 PDT 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 ==> <group>       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