INDB2_TIME is less than the ORIO_WTIME & INDB2_CPU TIME

Article Id: 16335
Status: Published
Updated On: 14-02-2018 07:51
Legacy Id: TEC1399597
Products:
CA Bind Analyzer for DB2 for z/OS , 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:



When viewing the Exception Detail screen, the INDB2_TIME is less than the  ORIO_WTIME & INDB2_CPU TIME. Also, the Fetch Count is zero when 10 rows were fetched. Is this correct?                                               

Environment:

Release:
Component: PDT

Resolution:

Both the INDB2_CPU & the ORIO_WTIME can be larger than the INDB2_TIME. For SQL requests that use CPU parallelism the INDB2_CPU & ORIO_WTIME are accumulated across all of the parallel tasks. Also, the INDB2_CPU includes both standard CPU and zIIP CPU time.