ENDTS and STARTTS Equal in DB2DPP File
search cancel

ENDTS and STARTTS Equal in DB2DPP File


Article ID: 30102


Updated On:


MICS Resource Management


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. 



Release: MICSAC00200-12.9-MICS-Resource Management-Accounting and Chargeback Opt