What is contained in the TR_MAIN_TIME & TR_MAIN_CPU fields on the Package/DBRM Summary Detail Display?

Document ID : KB000014189
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

This document states what values are contained in the TR_MAIN_TIME & TR_MAIN_CPU fields on the Package/DBRM Summary Detail Display.

Question:

What is contained in the TR_MAIN_TIME & TR_MAIN_CPU fields on the Package/DBRM Summary Detail Display?

Environment:
z/OS 1.11 and above.
Answer:

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.