Utility Access Summary Report and Fields (UTILITY)

This presents all utility access events according to the combination of OMEGAMON® for DB2® PE identifiers specified.

Use the following command to generate a utility access summary report.

 

AUDIT

    REPORT

       LEVEL (SUMMARY)

       TYPE  (UTILITY)

Note: For ORDER, INCLUDE and EXCLUDE, the utility name is used for PLANNAME.

Layout of a Member-Scope Audit Utility Access Summary Report

Here is a sample layout of a Member-Scope Audit Utility Access Summary report.

   LOCATION: LOCATI_2                   OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                   PAGE: 1-7
      GROUP: GROUP_1                              AUDIT REPORT - SUMMARY                        REQUESTED FROM: NOT SPECIFIED
     MEMBER: MEMBER_2                                 UTILITY ACCESS                                        TO: NOT SPECIFIED
  SUBSYSTEM: SYS2                             ORDER: PRIMAUTH-PLANNAME-OBJECT                      ACTUAL FROM: 01/30/15 04:21:44.17
DB2 VERSION: V10                                       SCOPE: MEMBER                                        TO: 01/30/15 07:19:20.25

PRIMAUTH UTILNAME DATABASE PAGESET        TOTAL
-------- -------- -------- --------      --------
AUTH_20  LOAD     DBASE1   PSET1                4
AUTH_30  LOAD     DBASE1   PSET1                4

*GRAND TOTAL*                                   8

Layout of a Group-Scope Audit Utility Access Summary Report

The layout of the default group-scope utility access summary report, ordered by member within database and page set, is shown in Layout of a Group-Scope Audit Utility Access Summary Report.

   LOCATION: LOCATI_2                   OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0)                   PAGE: 1-7
      GROUP: GROUP_1                              AUDIT REPORT - SUMMARY                        REQUESTED FROM: NOT SPECIFIED
                                                      UTILITY ACCESS                                        TO: NOT SPECIFIED
                                                       ORDER: OBJECT                               ACTUAL FROM: 01/30/15 04:21:44.17
DB2 VERSION: V10                                       SCOPE: GROUP                                         TO: 01/30/15 07:21:20.25

DATABASE PAGESET   MEMBER        TOTAL
-------- -------- --------      --------
DBASE1   PSET1    MEMBER_2             8
                  MEMBER_3             8

*GRAND TOTAL*                         16

Field description

The utility access summary report contains the following fields:

OMEGAMON for Db2 PE Identifiers

The identifiers define the order of the Audit data reported. Up to three identifiers are printed.

The defaults are:

For member-scope reports, PRIMAUTH-PLANNAME-OBJECT
For group-scope reports, OBJECT

For group-scope reports, MEMBER is considered the last ORDER identifier and is automatically added as the second, third, or fourth identifier.

DATABASE

The name of the database that contains the auditable DB2 object or the decimal DBID of that database.

PAGESET

The name or the decimal PSID of the page set that contains the DB2 object.

TOTAL

All utility access operations. Total number of IFCID 024 records for this set of identifiers.