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

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

book

Article ID: 112486

calendar_today

Updated On:

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