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/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem 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.