ENDTS and STARTTS Equal in DB2DPP File

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

In the DB2DPP (DB2 Package/DBRM Activity) File in CA MICS, the ENDTS and STARTTS  data element values are equal in the DETAIL timespan.

ENDTS is the SMF timestamp of the SMF header. There can be any number of packages or stored procedures for a DB2 thread.  The only field in a package section that tells anything about time is the elapsed time of all executions of the package. If a DB2 thread executed 18 packages, each of the 18 packages would have its own elapsed time set. There is no reliable way to set a start timestamp from that. 

So, since STARTS is a common element in nearly all MICS files, for DPP, it is set equal to ENDTS.