Statistics Report and Trace Blocks

This section shows the individual blocks presented by OMEGAMON for Db2® PE reports and traces together with a short explanation of each field. The examples shown are taken from the statistics long reports and traces.

The layout of the Statistics report and trace blocks is the same. Statistics traces show times and events as delta records describing the activity between two consecutive Db2 record pairs. Statistics reports show times and events over a user-specified period of time.

Each block is presented in the default layout. Some block can have columns, rows or fields that are not included in the default layout. You can include columns, rows, and fields not shown in the default layouts with user-tailored reporting (UTR).

In the short report and trace, field names can differ slightly from the names shown in the long report or trace.

If a counter value or specific information in reports, in windows, or on panels is not shown, the following notation is used to indicate the reason:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.