ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
INDB2_TIME is less than the ORIO_WTIME & INDB2_CPU TIME
book
Article ID: 16335
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
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.