.
Times (class 5)—IFI time
This topic describes the Times (class 5)—IFI time distribution section of the Accounting detail trace—long report (BACCTLT) and the Accounting summary—long report (BACCTDR).
------------ -------------- -------------- --------------
ELAPSED TIME 0.219540 0.020884 0.000000
NONNESTED 0.219540 0.020884 N/A
STORED PROC 0.000000 0.000000 N/A
UDF 0.000000 0.000000 N/A
TRIGGER 0.000000 0.000000 N/A
CP CPU TIME 0.003412 0.001759 0.000000
AGENT 0.003412 0.001759 N/A
NONNESTED 0.003412 0.001759 0.000000
STORED PRC 0.000000 0.000000 N/A
UDF 0.000000 0.000000 N/A
TRIGGER 0.000000 0.000000 N/A
PAR. TASKS 0.000000 0.000000 N/A
S/E ELIGIBL 0.000000
S/E CPU 0.000000 0.000000 N/A
TRIGGERS 0.000000
SUSPEND TIME 0.000000 0.019110 N/A
AGENT N/A 0.019110 0.000000
PAR.TASKS N/A 0.000000 N/A
STORED PR 0.000000
NOT ACCOUNT N/A 0.000015 N/A
DB2 ENT/EXIT N/A 106.535430 N/A
EN/EX-STPROC N/A 0.000000 N/A
EN/EX-UDF N/A 0.000000 N/A
DCAPT DESCR N/A N/A 0.000000
LOG EXTRACT N/A N/A 0.000000
The following table describes the fields in the Times (class 5)—IFI time section:
Field | Description |
|---|---|
ELAPSED TIME | Elapsed time processing IFI calls (QIFAAIET) This value is the elapsed time processing Instrumentation Facility Interface READA and READS requests to process Db2 trace data. This information is only gathered if accounting class 5 is active. |
CPU TIME | CPU time processing IFI calls (QIFAAITT) This value is the CPU time consumed processing Instrumentation Facility READA and READS requests to process Db2 trace data. |
AGENT | Accumulated CPU time spent processing IFI calls (QIFAAITT) This time is the same as the TCB time (class 5). |
DCAPT DESCR | Elapsed time processing data capture describes (QIFAAMBT) This value is the elapsed time processing data capture describe information during 'IFI READS' calls for IFCID 185 (Db2 data capture before and after image data). The Db2 catalog must be accessed to obtain this information which describes data in log records. Tuning Tip: The data capture facility can be used for hot site disaster recovery or sophisticated audit mechanisms. This field is associated with the time spent gathering the log record data in IFCID 185. |
LOG EXTRACT | Elapsed time extracting log data for IFCID 185 (QIFAAMLT) This value is the elapsed time processing log records as a result of IFI READS calls for IFCID 185 (data capture before and after image log data). This time is associated with the elapsed time processing data capture describes. Tuning Tip: The data capture facility can be used for hot site disaster recovery or sophisticated audit mechanisms. This field is associated with the time spent gathering the log record data capture describes in IFCID 185. |