V 5.2.0: Update to the Report Reference manual of IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS

Manual


Abstract

This document updates the IBM® Tivoli® OMEGAMON® XE for DB2® Performance Expert on z/OS and IBM Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS Version 5.2.0: Report Reference manual, SH12-6991-00.

Update 1* in PM99040 (November 2013): The information in the following chapter is updated to describe new fields to show autonomous procedures:
- Chapter 40. IFCID Record Blocks -> "IFCID 003 - Instrumentation Accounting Data"

Update 2* in PM99280 (December 2013): The information in the following section describes how to evaluate short or long strings in SQL activity traces and reports:
- Chapter 42. Introduction to the SQL Activity Report Set -> Explanation of short and long field

Update 3* in PM98092 (December 2013): The information in the following chapters is updated to show new or updated reports and traces for evaluating accelerator data from IBM DB2 Analytics Accelerator for z/OS:
- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Accelerator Data - Prior to Version 4"
- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Accelerator Data - Subsystem Perspective - for
Version 4" (new)
- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Accelerator Data - Accelerator Perspective - for
Version 4" (new)
- Chapter 49. Statistics Report and Trace Blocks -> "Accelerator Data - Prior to Version 4"
- Chapter 49. Statistics Report and Trace Blocks -> "Accelerator Data - for Version 4" (new)

Update 4* in PM99308 (February 2014):
The information in the following chapter is new:
- Chapter 40. IFCID Record Blocks -> "IFCID 360 - Incrementally Rebound Queries"

Update 5* in PI08288 (March 2014):
The information in the following chapters is new or updated for evaluating accelerator data and eligible DB2 times:
- Chapter 5. Accounting Default Layouts -> "Measured/Elig Times" (new)
- Chapter 5. Accounting Default Layouts -> "Query Parallelism"
- Chapter 5. Accounting Default Layouts -> "Service Units"
- Chapter 5. Accounting Default Layouts -> "Times - Class 1 - Application Time"
- Chapter 40. IFCID Record Blocks -> "IFCID 003 / 147 - Instrumentation Accounting Data"
- Chapter 40. IFCID Record Blocks -> "IFCID 106 - Miscellaneous Installation Parameters"
- Chapter 54. System Parameters Report Blocks ->"Query Accelerator Preferences (DSNTIP82)"
- Chapter 54. System Parameters Report Blocks ->"Other System Parameters"

Update 6* in PI12538 (April 2014):
The information in the following chapters is updated:
- Chapter 40. IFCID Record Blocks -> "IFCID 225 - Statement Cache / XPROC Detail"
- Chapter 49. Statistics Report and Trace Blocks -> "DBM1 Storage Above 2 GB"

Update 7* in PI09581 (April 2014):
The information in the following chapters is new or updated for evaluating accelerator data and eligible DB2 times:
- Chapter 5. Accounting Default Layouts -> "Package Identification - Report"
- Chapter 5. Accounting Default Layouts -> "Package Identification - Trace"
- Chapter 5. Accounting Default Layouts -> "Package General (Short Report)"
- Chapter 40. IFCID Record Blocks -> "IFCID 239 - Package/DBRM Accounting Data"

Update 8* in PI16762 (May 2014):
The following information has been updated and added:
- Chapter 40. IFCID Record Blocks -> "IFCID 366 - Incompatible Functions Executed"
- Chapter 40. IFCID Record Blocks -> "IFCID 376 - Incompatible Functions Executed" (new)

Update 9* in PI14759 (May 2014):
The following information has been updated:
- Chapter 50. "The Statistics File Data Set and Output Records"-->"Converting Data Sets"
- Chapter 51. "The Statistics Save-File Utility" --> "Converting Data Sets"

Update 10* in PI12870 (June 2014):
The following information has been updated:
- Chapter 5. "Accounting Default Layouts"-->"Times - Class 3 - Suspensions"
- Chapter 40. "IFCID Record Blocks" --> "IFCID 003 - Instrumentation Accounting Data"

Update 11* (June 2014):
The following information has been updated:
- Chapter 49. "Statistics Report and Trace Blocks"-->"Authorization Management"

Update 12* in PI22243 (August 2014):
The following information has been updated:
- Chapter 49. "Statistics Report and Trace Blocks"-->"Accelerator Data - Prior to Version 4"
- Chapter 49. "Statistics Report and Trace Blocks"-->"Accelerator Data - Version 4"
- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Accelerator Data - Subsystem Perspective - V4"

Update 13* (September 2014):
The following field description has been modified: Q8STDSKU



*Note: The chapter structure in the updated PDF attachments of this document does not reflect the chapter structure of the existing book.

Content

Update 13* (September 2014)

The field description of Q8STDSKU has been modified in:

  • IFCID 002 - Accelerator Data - Prior to V4
    DISK STORAGE AVAILABLE - IN USE (%)
    The current disk utilization of the accelerator worker nodes, expressed as percentage of the used I/O channels/resources.
    Field Name:
    Q8STDSKU
  • IFCID 002 - Accelerator Data - Accelerator Perspective - V4
    WORKER NODES DISK UTILIZATION (%)
    The current disk utilization of the accelerator worker nodes, expressed as percentage of the used I/O channels/resources.
    Field Name:
    Q8STDSKU
  • Accelerator Data - Prior to Version 4
    DISK STORAGE AVAILABLE - IN USE (%)
    The current disk utilization of the accelerator worker nodes, expressed as percentage of the used I/O channels/resources.
    Field Name:
    Q8STDSKU
  • Accelerator Data - Version 4
    WORKER NODES DISK UTILIZATION (%)

    The current disk utilization of the accelerator worker nodes, expressed as percentage of the used I/O channels/resources.
    Field Name: Q8STDSKU

Update 12* in PI22243 (August 2014)

The following information has been updated in the accelerator sections:


Update 11* (June 2014)

The following information has been updated:

  • Chapter 49. "Statistics Report and Trace Blocks"-->"Authorization Management"


The description of the following fields has been updated in:


PKG-AUTH UNSUCC-CACHE
The number of unsuccessful package EXECUTE authorization checks in the package authorization cache. No applicable entry was found in the cache and DB2 catalog access was used.
Field Name: QTPACNOT

RTN-AUTH UNSUCC-CACHE
Number of unsuccessful authorization checks for user-defined function or stored procedure EXECUTE authority because no applicable entry was found in the routine authorization cache.
Field Name: QTRACNOT

Update 10* in PI12870 (June 2014)

The description of the following fields has been updated in:

  • Chapter 5. " Accounting Default Layouts"-->"Times - Class 3 - Suspensions"
  • Chapter 40. "IFCID Record Blocks" --> "IFCID 003 - Instrumentation Accounting Data"

LOCK/LATCH(DB2+IRLM) - AVERAGE TIME/ELAPSED TIME
This field depends on the DB2 version that is installed:
  • DB2 10 or later: The sum of the accumulated wait time due to local contention for locks and the accumulated wait time due to latch contention.
  • Prior to DB2 10: The accumulated lock and latch elapsed time. It indicates the elapsed time that the allied agent waited for locks and latches in DB2. This value does not include suspensions because of group-level lock contentions in a data sharing environment. When the event completes, the ending time is used to calculate the total elapsed wait time. The result is added to the previously saved lock and latch wait time in DB2. If class 9 is not active, the time shown does not include the time for internal latching.
Field Name: AWTLOLA


IRLM LOCK+LATCH - AVERAGE TIME/ELAPSED TIME
This field depends on the DB2 version that is installed:
  • DB2 10 or later: The accumulated wait time because of local contention for locks. The term local contention is used to differentiate from global contention (which is reported in QWACAWTJ). Local contention does not require intersystem communication. The contention is detected and resolved entirely within this subsystem.
  • Prior to DB2 10: The value is reported in field AWTLOLA.
Field Name: QWACAWTL
This is an exception field.




Update 9* in PI14759 (May 2014)
The description of Aggregated Accounting records for Statistics has been added to:
Update 8* in PI16762 (May 2014)

The following information has been updated and added:




Update 7* in PI09581 (April 2014)

The field descriptions for the following chapters are updated:

-Chapter 5. Accounting Default Layouts -> "Package Identification - Report" :
The following information is updated:

Chap5_Package_Identification_Report.pdf

-Chapter 5. Accounting Default Layouts -> "Package Identification - Trace" :
The following information is updated:

Chap5_Package_Identification_Trace.pdf

-Chapter 5. Accounting Default Layouts -> "Package General (Short Report)" :
The following information is updated:

Chap5_Package_General_(Short_Report).pdf

-Chapter 40. IFCID Record Blocks -> "IFCID 239 - Package/DBRM Accounting Data":
The following information is updated:

Chap40_IFCID_239_Package_DBRM_Accounting_Data.pdf




Update 6* in PI12538 (April 2014)

The following information is updated:

-Chapter 40. IFCID Record Blocks -> "IFCID 225 - Statement Cache / XPROC Detail" :
The following information is updated:

Chap40_IFCID225_Statement_Cache_XPROC_Detail.pdf

-Chapter 49. Statistics Report and Trace Blocks -> "DBM1 Storage Above 2 GB" :
The following information is updated:

Chap49_DBM1_Storage_Above_2_GB.pdf

Update 5* in PI08288 (March 2014)

The information in the following chapters is updated to show new or updated reports and traces for evaluating accelerator data and eligible DB2 times:

-Chapter 5. Accounting Default Layouts -> "Measured/Elig Times" (new):
The following Accounting data block is new:

Chap5_AccountingDefaultLayouts_MeasuredElig_Times.pdfChap5_AccountingDefaultLayouts_MeasuredElig_Times.pdf

-Chapter 5. Accounting Default Layouts -> "Query Parallelism":

Chap5_AccountingDefaultLayouts_Query_Parallelism.pdfChap5_AccountingDefaultLayouts_Query_Parallelism.pdf

-Chapter 5. Accounting Default Layouts -> "Service Units" :

Chap5_AccountingDefaultLayouts_Service_Units.pdfChap5_AccountingDefaultLayouts_Service_Units.pdf

-Chapter 5. Accounting Default Layouts -> "Times - Class 1 - Application Time" (layout modified):
Field name AWACZEL (SECP CPU) and its description has been moved to the new Accounting data block: Measured/Elig Times (see above).

- Chapter 40. "IFCID Record Blocks"->'IFCID 003 - Instrumentation Accounting Data'
Class 2 of the IFCID record blocks in IFCID 003 and IFCID 147 has been updated:

Chap40_IFCID_003_Instrumentation_Accounting_Data.pdfChap40_IFCID_003_Instrumentation_Accounting_Data.pdf

- Chapter 40. IFCID Record Blocks -> "IFCID 106 - Miscellaneous Installation Parameters"

Chap40_IFCID_106_Miscellaneous_Installation_Parameters.pdfChap40_IFCID_106_Miscellaneous_Installation_Parameters.pdf

- Chapter 54. System Parameters Report Blocks ->"Query Accelerator Preferences DSNTIP82)"

Chap54_System_Parameters_Query_Accelerator_Preferences_(DSNTIP82).pdfChap54_System_Parameters_Query_Accelerator_Preferences_(DSNTIP82).pdf

- Chapter 54. System Parameters Report Blocks ->"Other System Parameters"

Chap54_System_Parameters_Report_Blocks_Other_System_Parameters.pdfChap54_System_Parameters_Report_Blocks_Other_System_Parameters.pdf

Update 4* in PM99308 (February 2014)

The information in the following chapter is new:
- Chapter 40. IFCID Record Blocks -> "IFCID 360 - Incrementally Rebound Queries"
Chap_40_IFCID_360_Incrementally_Rebound_Queries.pdfChap_40_IFCID_360_Incrementally_Rebound_Queries.pdf

Update 3* in PM98092 (December 2013)

The information in the following chapters is updated to show new or updated reports and traces for accelerator data and eligible times from IBM DB2 Analytics Accelerator for z/OS:


- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Accelerator Data - Prior to Version 4"

Chap_40_IFCID 002_Accelerator_Data_Prior_V4.pdfChap_40_IFCID 002_Accelerator_Data_Prior_V4.pdf
- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Accelerator Data - Subsystem Perspective - for Version 4" (new)
Chap_40_IFCID 002_Acc_Data_Subsystem_Perspective_V4.pdfChap_40_IFCID 002_Acc_Data_Subsystem_Perspective_V4.pdf

- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Accelerator Data - Accelerator Perspective - for Version 4" (new)

Chap_40_IFCID 002_Acc_Data_Accelerator_Perspective_V4.pdfChap_40_IFCID 002_Acc_Data_Accelerator_Perspective_V4.pdf
- Chapter 49. Statistics Report and Trace Blocks -> "Accelerator Data - Prior to Version 4"

Chap_49_Statistics_Accelerator_Data_Prior_V4.pdfChap_49_Statistics_Accelerator_Data_Prior_V4.pdf
- Chapter 49. Statistics Report and Trace Blocks -> "Accelerator Data - for Version 4" (new)

Chap_49_Statistics_Accelerator_Data_V4.pdfChap_49_Statistics_Accelerator_Data_V4.pdf




Update 2* in PM99280 (December 2013)

-Chapter 42. Introduction to the SQL Activity Report Set -> Explanation of short and long fields:
The information in the following section describes how to evaluate short and long strings in SQL activity traces and reports:

Explanation of short and long fields.pdfExplanation of short and long fields.pdf


Update 1* in PM99040 (November 2013)

-Chapter 40. "IFCID Record Blocks" -> 'IFCID 003 - Instrumentation Accounting Data':
New fields are provided to show autonomous procedures:

Chap40_IFCID 003 - Instrumentation Accounting Data.pdfChap40_IFCID 003 - Instrumentation Accounting Data.pdf

*Note: The chapter structure in the updated PDF attachments of this document does not reflect the chapter structure of the existing book.


Related information

DB2 Tools Product Page
Tivoli OMEGAMON XE Family of Products welcome page
Tivoli Documentation Central

Publication number

SH12-6991-00

Copyright date

1985, 2013

Original publication date

2013/10/25

Product Alias/Synonym

OMEGAMON XE for DB2 PE
OMEGAMON XE for DB2 PM

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 Tools for z/OS
IBM Tivoli OMEGAMON XE for DB2 PE / PM / BPA

Software version:

5.2.0

Operating system(s):

z/OS

Reference #:

7040297

Modified date:

2014-09-23

Translate my page

Machine Translation

Content navigation