What is the meaning of a diference between CPU and Elpased time reported in Detector and in MAINVIEW accounting reports?.

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

The time data, CPU and Elapsed, reported in Detector has a difference with the time data reported in MAINVIEW accounting reports. For example, for a specific Plan the accounting detail times are larger in MAINVIEW reports. The accounting times reported in MAINVIEW reports are based on SMF data.

 

Environment

Release:
Component: PDT

Resolution

The Detector times include only the times that are used in SQL execution, and are not equivalent to the times which would be found on SMF data. The SMF/MAINVIEW data includes all activitiy that occurred in DB2 for the Thread, which would include Plan/Package allocation, Thread initialization as well as some Detector overhead and SQL execution, so it is expected that the Detector number would be lower that those reported by SMF and/or MAINVIEW, Detector reports only SQL execution.