Headers Used in Accounting

This topic describes the header of the Accounting report layout.

OMEGAMON® for DB2® PE header information is printed at the top of each page of an Accounting report or trace. For a report, the header differs depending on whether it is a member-scope or group-scope report.

Accounting Report Header Member-Scope

Here is a sample header for an Accounting report generated with member-scope.

   LOCATION: PMODBN1                    OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                   PAGE: 1-1
      GROUP: DBN1                                ACCOUNTING REPORT - SHORT                      REQUESTED FROM: NOT SPECIFIED
     MEMBER: SN11                                                                                           TO: NOT SPECIFIED
  SUBSYSTEM: SN11                                 ORDER: PRIMAUTH-PLANNAME                       INTERVAL FROM: 01/30/15 22:53:32.60
DB2 VERSION: V10                                      SCOPE: MEMBER                                         TO: 01/30/15 22:50:05.07

Accounting Report Header-Group-Scope

Here is a sample header for an Accounting report generated with group-scope.

   LOCATION: DSNCAT                     OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                   PAGE: 1-1
      GROUP: DSNCAT                              ACCOUNTING REPORT - SHORT                      REQUESTED FROM: NOT SPECIFIED
                                                                                                            TO: NOT SPECIFIED
                                                  ORDER: PRIMAUTH-PLANNAME                       INTERVAL FROM: 01/30/15 18:47:13.28
DB2 VERSION: V10                                      SCOPE: GROUP                                          TO: 01/30/15 19:55:28.69

Accounting Trace Header

Here is a sample header for an Accounting trace.

   LOCATION: PMODBN1                    OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                   PAGE: 1-1
      GROUP: DBN1                                ACCOUNTING TRACE - SHORT                       REQUESTED FROM: NOT SPECIFIED
     MEMBER: SN11                                                                                           TO: NOT SPECIFIED
  SUBSYSTEM: SN11                                                                                  ACTUAL FROM: 01/30/15 22:53:32.60
DB2 VERSION: V10                                                                                     PAGE DATE: 01/30/15

Description of the Accounting header fields

The Accounting headers, shown in Accounting Report Header Member-Scope, Accounting Report Header-Group-Scope, and Accounting Trace Header contain the following information:
LOCATION
The DB2 reporting location. If the location name is not available, the DB2 data sharing group name is printed in this field. If the DB2 data sharing group name does not exist, the DB2 subsystem ID is printed.
GROUP
The name of the DB2 data sharing group. This field shows N/A if there is no group name.
MEMBER
The name of the DB2 data sharing member or the member name of the DB2 subsystem. This field shows N/A if there is no member name.

This field is not printed on the report page showing the GROUP BUFFERPOOLS PARAMETERS.

SUBSYSTEM
The ID of the DB2 subsystem that generated the data. This field is not printed on the report page showing the GROUP BUFFERPOOLS PARAMETERS.
DB2 VERSION
The DB2 version number of the subsystem that generated the data.
OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (VnRnMn)
The product name and the version, release, and modification level.
Title - layout
The title of the report and the layout. The layout can be a default layout provided with OMEGAMON for Db2 PE or a layout you have tailored yourself.
ORDER
If the ORDER option of the REPORT or TRACE subcommand was used to arrange the report entries, the selected keywords are shown in this field. Depending on the context, the OMEGAMON for Db2 PE identifiers by which lock events are grouped are shown here.
SCOPE
Scope of the report or trace, this can be MEMBER or GROUP. A member-scope report or trace shows data from a group for each individual member. In a group-scope report or trace, the data from individual members is consolidated and presented for the entire group.
PAGE
The page number in the format lll-nnnnnn, where lll denotes the location number within the report and nnnnnn the page number within the location.
REQUESTED FROM and TO
The FROM and TO dates and times specified in the REPORT or TRACE subcommand.

If both FROM and TO dates and times are omitted from the REPORT subcommand, the FROM and TO dates and times specified in GLOBAL are printed. If only the FROM date and time or only the TO date and time has been specified, NOT SPECIFIED is printed for the unspecified value.

If FROM and TO are not specified in REPORT or GLOBAL, NOT SPECIFIED appears for both the FROM and TO values.

If you have specified FROM and TO times without dates in REPORT or GLOBAL, ALL DATES is printed along with the specified times.

INTERVAL FROM
The start date and time of the first reduction interval covered by the report. If REDUCE is not specified, the INTERVAL defaults to 0 and the timestamps of the first and last events are printed.
INTERVAL TO
The end date and time of the last reduction interval covered by the report. If REDUCE is not specified, the INTERVAL defaults to 0 and the timestamps of the first and last events are printed.
PAGE DATE
The date of the timestamps printed on this page. A page break occurs at the change of the date. This is useful if a trace page contains more than one entry and the date is not shown for each entry.