INDB2_TIME is less than ORIO_WTIME and INDB2_CPU time within Detector

Products

• Detector for DB2 for z/OS

Issue/Introduction

When viewing the Detector for Db2 for z/OS (PDT) Exception Detail screen, the INDB2_TIME is less than the ORIO_WTIME and INDB2_CPU time.

Resolution

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