What is Unaccounted For Time means in Detector Plan Activity Report?

book

Article ID: 16013

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction



What is  Unaccounted for time means in this repot  in CA-Detector  Plan Activity Report? 

Environment

Release:
Component: PDT

Resolution

Field:  UNACC_TIME                                                       

                                                                          

Description:  The time incurred by the program while it is executing SQL that is not accounted for by the IFCID accounting         fields. This field has no specific meaning but serves as an indication of the amount of SQL execution time not specifically         accounted for by the IFCID accounting fields.  This metric is only valid when Accounting Class 3 is active.                                 This field does not correspond to any specific IFCID field. It is equivalent to IFCID field QWACASC minus the following IFCID fields:   QWACAJST, QWACAWTI, QWACAWTL, QWACAWTR, QWACAWTW, QWACAWTE, QWACAWTP, QWACAWTG, QWACAWTJ, QWACSPTT, QWACAWLG, QWACUDTT, QWACTRTT, QWACTRTE, QWACAWTK, QWACAWTM, QWACAWTN, QWACAWTO, QWACAWTQ, QWAXALOG, QWAXAWDR, QWAXAWCL, QWAXAWAR, QWAXOCSE, QWAXSLSE, QWAXDSSE, QWAXOTSE, QWAXIXLT, QWACCLS2_ZIIP, and  QWACALBW.                                          

The data Detector uses to compute this field is not directly obtained from the IBM instrumentation facility, but the field definitions are similar. Detector reports this information at different levels of granularity than the IFCID records may indicate. For more information on IFCIDs, refer to the IBM DB2 Administration Guide.