Why has the SQL Data Sharing Group error count decreased during the current interval for CA Detector?
Article ID: 112486
Updated On:
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
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?
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):
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
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
Feedback
Yes
No
Powered by
