Sysview for DB2 (IDB2) shows irregular intervals for Stats history

book

Article ID: 131305

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

In a data sharing group, IDB2 Stats history (option 2) lists the data at irregular intervals rather than 1 minute intervals as defined in the IDDCPRMS sysparm member..
Other Data Collectors list data with 1 minute intervals as expected.  Could external factors contribute to irregular time intervals being displayed?  

Cause

The IDB2 DC joblog reflects problems getting data from DB2 for the given time period:
DBG43004I DB2D 22:24:01 IFI FUNCTION READS COMPLETED WITH RETURN CODE 0008 AND REASON CODE 00E60838 
DBG43005I DB2D 22:24:01 IFCA DIAGNOSTIC INFO IS: 00000000 00000000 00000000 
DBG43004I DB2D 22:29:35 IFI FUNCTION READS COMPLETED WITH RETURN CODE 0008 AND REASON CODE 00E60838 
DBG43005I DB2D 22:29:35 IFCA DIAGNOSTIC INFO IS: 00000000 00000000 00000000 
-
Explanation of the Reason Code 00E60838: 
On a READS request for IFCID 0254, a resource was unavailable while attempting to collect statistics for a specific group buffer pool. 

Environment

IDB2 r19, DB2 v12

Resolution

The irregularities are likely attributable to known CPU-contention on the system.