What is contained in the TR_MAIN_TIME and TR_MAIN_CPU fields on the Detector Package/DBRM Summary Detail Display

Products

• Detector for DB2 for z/OS

Issue/Introduction

What is contained in the TR_MAIN_TIME and TR_MAIN_CPU fields on the Detector for Db2 for z/OS (PDT) Package/DBRM Summary Detail Display.

Resolution

The TR_MAIN_CPU is all CPU used by the trigger activity, while the INDB2_CPU is just for the SQL request processing.
Trigger activity TR_MAIN_CPU for package PK1 will reflect only the trigger time for that package, not the other packages that use the same trigger. 
The TR_MAIN_CPU and TR_MAIN_TIME will be larger than the sum of the INDB2_CPU for the trigger requests.