Interpreting activity reports

This topic shows examples of a summary report and a detail report and describes the layout and the elements of these reports. This topic helps to understand the host reports created by Buffer Pool Analyzer.

Related tasks:
General remarks:
  1. The reported data reflects the performance for the interval for which trace data was collected and for the time frame that was specified with the GLOBAL and the BPACTIVITY command.
  2. Activity reports are composed of several sections in a fixed sequence. If data for a specific section is not available, a "no data to report" statement or similar is shown. For example, if group buffer pool specific information cannot be reported because the data was collected from a DB2® subsystem that is not a member of a data sharing group, several sections in the summary report have no data to report.
  3. 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.

Related reading: Summary reports and detail reports show several elements that can be changed by means of the DB2 ALTER BUFFERPOOL command. For details on how to change them see the Start of changeIBM DB2 11 for z/OS: Command ReferenceEnd of change.

The following topics provide additional information:



Feedback