Output from OMEGAMON AI for Db2 reports

Edit online

This section helps you understand output values, date formats, and time formats.

Usage

The output from OMEGAMON AI for Db2 is one, or more, data sets containing the reports you requested, and a set of log file data sets. These log files are described in the Report Reference. The reports and traces produced are described and explained in detail in the relevant sections of this information.

Large and missing values in reports

Values printed on reports can be either total values or average values.

If there is insufficient space to print a value on a report or trace, a rounded value is printed followed by one of the following letters to indicate the magnitude:
K
kilo — 103
M
mega — 106
G
giga — 109
T
tera — 1012
P
peta — 1015
E
exa — 1018
The letter is printed directly after the number, without blank spaces. There can, however, be decimal places, as follows:
  • Valid conversions of 12 345 include 12K, 12.35K, and 12.3K.
  • Valid conversions of 1 234 567 include 1M, 1.2346M, and 1235K.
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.

Default date format

By default, OMEGAMON AI for Db2 shows dates as mm/dd/yy. You can change this format to suit your own national language, or corporate convention by using DATEFORMAT. For more information, see DATEFORMAT subcommand option.

This example shows the default date format as printed in the header of an Accounting short report.
Figure 1. Accounting report - short
    LOCATION: STM4D61Y                   IBM Z OMEGAMON AI FOR DB2 (V6R1M0)                       PAGE: 1-1
       GROUP: N/P                                 ACCOUNTING REPORT - SHORT                      REQUESTED FROM: 11/05/15 23:45
      MEMBER: N/P                                                                                            TO: 11/05/15 23:50
   SUBSYSTEM: Y61Y                              ORDER: ENDUSER-WSNAME-TRANSACT                    INTERVAL FROM: 11/05/15 23:48:01.86
 DB2 VERSION: V13                                      SCOPE: MEMBER                                         TO: 11/05/15 23:53:34.20

Elapsed time formats

Time values are presented in one of the following formats:
dd hh:mm:ss.ffffffff
where:
dd
represents days
hh
represents hours
mm
represents minutes
ss
represents seconds
ffffffff
represents the fractions of a second up to 8 decimal places.

For example, a time value of 1:30:25.10 represents 1 hour, 30 minutes, and 25.1 seconds.

Some of the reports that use this format might not report days (dd) or hours (hh).

ssssssss.ffffffff
where:
ssssssss
represents seconds
ffffffff
represents the fractions of a second up to 8 decimal places.

The actual number of decimal places varies from one field to another.

Some time fields can be rounded. If there is insufficient space to print a time value, the time is rounded by removing decimal places as required. For elapsed times, a rounded value is printed.