DB2 STORED PROC TIME IN CICS

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

Description:

Is DB2 Stored Procedure time, invoked from CICS, included in the CPU time captured to the CICS monitor record?

Solution:

The stored procedure TCB time reported in DSUSP2TM is not included in the MICS/CICS elements CSUCPRTM, CSUTCBTM, and CSUCPUTM.

These latter elements are populated from the USRCPUT field in the type 110 performance record. CICS starts a transaction on an L8 TCB which also processes DB2 threads that are started by the CICS transaction. However, only the DB2 processing that takes place on the initial CICS TCB is counted in the USRCPUT field and hence in the CSU TCB time elements listed above. So activity reported by DSUTCBTM is included in the CSU elements. There is an exception to this for parallel DB2 transactions. Parallel activity takes place on a different TCB. Therefore, activity designated as parallel by the DB2PTASK element is not included in the CSU file.

In IBM terms, the DSUSP2TM element reports activity found in the QWACSPTT field of the type 101 record. QWACSPTT values are a subset of QWACSPCP. QWACSPCP is not reported in the USRCPUT field of the type 110 performance record.