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

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

book

Article ID: 131305

calendar_today

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

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?  

Environment

IDB2 r19, DB2 v12

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. 

Resolution

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