Aggregated Accounting Statistics

This topic shows detailed information about Statistics - Aggregated Accounting Statistics.

IFCID 369 contains aggregated Accounting data from IFCID 3 listed by connection type.

IFCID 369 is started using the START TRACE command for STATISTICS CLASS(9). IFCID 3 must also be enabled (ACCOUNTING CLASS(1)) to get 369 trace records. IFCID 369 values are aggregated each time an IFCID 3 is written and contain total values. In the Statistics reports, IFCID 369 delta values are calculated to show which IFCID 3 events occurred in a Statistics interval.

In contrast to Accounting reports, the IFCID 369 statistics performance metrics cannot distinguish between IFCID 3 records for parallel and non-parallel threads. In Accounting, the elapsed times of parallel threads are derived from IFCID 3 of the originating thread. In IFCID 369, all times (even the elapsed times of the originating thread and parallel subtasks) are aggregated and shown as such in the Statistics report. That is why IFCID 369 can provide more diagnostics on what is currently happening in a Db2 subsystem and whether there are bottlenecks (also for parallel subtasks).

CONNTYPE   CL1 ELAPSED       CL1 CPU    CL1 SE CPU   CL2 ELAPSED       CL2 CPU    CL2 SE CPU      CL3 SUSP   CL2 NOT ACC  QUANTITY
--------  ------------  ------------  ------------  ------------  ------------  ------------  ------------  ------------  --------
BATCH         0.000000      0.000000      0.000000      0.000000      0.000000      0.000000      0.000000      0.000000      0.00
CICS               N/P           N/P           N/P           N/P           N/P           N/P           N/P           N/P      0.00
DDF        3:20.927303      9.873839      8.240478     55.917303      8.697064      6.742272     39.852088      7.368151  15895.00
IMS                N/P           N/P           N/P           N/P           N/P           N/P           N/P           N/P      0.00
RRSAF      1:04.091521      0.143129      0.000000      0.050749      0.044200      0.000000      0.000062      0.006487     10.00
UTILITY      21.317271      0.712988      0.031434      1.224435      0.189245      0.031434      0.987360      0.047829     72.00

CL1 ELAPSED

The class 1 elapsed time aggregated by connection type. See also the description of Accounting field ADRECETT.

Note: In contrast to ADRECETT, elapsed times of parallel records are included in SDRECETT.

Field Name: SDRECETT

CL1 CPU

The class 1 CPU time aggregated by connection type. See also the description of Accounting field ADCPUT.

Field Name: SDCPUT

CL1 SE CPU

The sum of several accumulated CPU times consumed while running on an IBM specialty engine in all environments and aggregated by connection type. See also the description of Accounting field AWACC1Z.

Field Name: SWACC1Z

CL2 ELAPSED

The class 2 elapsed time aggregated by connection type. See also the description of Accounting field ADDB2ETT.

Note: In contrast to ADDB2ETT, elapsed times of parallel records are included in SDDB2ETT.

Field Name: SDDB2ETT

CL2 CPU

The class 1 CPU time aggregated by connection type. See also the description of Accounting field ADDBCPUT.

Field Name: SDDBCPUT

CL2 SE CPU

The accumulated and consumed class 2 time on an IBM specialty engine aggregated by connection type. See also the description of Accounting field AWACC2Z.

Field Name: SWACC2Z

CL3 SUSP

The waiting time for all types of class 3 suspensions aggregated by connection type. See also the description of Accounting field ADTSUST.

Field Name: SDTSUST

CL2 NOT ACC

The time not accounted in Db2 and aggregated by connection type. See also the description of Accounting field ADNOTACC.

Note: In contrast to ADNOTACC, unaccounted times of parallel records are included in SDNOTACC.

Field Name: SDNOTACC

QUANTITY

The number of parallel child agents, Accounting intervals, or autonomous procedures rolled up for all threads of the connection type. See also the description of Accounting field QWACPCNT.

Field Name: SWACPCNT