IBM Support

V 5.2.0: Update to the Report Reference manual, 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.

Content

The most recent update is listed first.


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



Update 17
Date of change: June 2017
Topics: Multiple
Change description: The following two chapters will be updated, to cover information in APAR PI74256:
  • Chapter 40, IFCID Record Blocks
  • Chapter 54, System Parameters Report Blocks


Chapter 40, IFCID Record Blocks:
IFCID 106 - Miscellaneous Installation Parameters
SPT01 MAX LENGTH
The maximum length in bytes of LOB columns in the SPT01 directory
space that are maintained in the base table. This field corresponds to field
SPT01 INLINE LENGTH on installation panel DSNTIPA2. The ZPARM
name is SPT01_INLINE_LENGTH in DSN6SPRM.

-1 is displayed for NOINLINE.
0 is displayed for default value.

Field Name: QWP4S1IL

Chapter 54, System Parameters Report Blocks
Other System Parameters
SPT01 INLINE LENGTH (SPT01_INLINE_LENGTH)
The maximum length in bytes of LOB columns in the SPT01 directory
space that are maintained in the base table. This field corresponds to field
SPT01 INLINE LENGTH on installation panel DSNTIPA2. The ZPARM
name is SPT01_INLINE_LENGTH in DSN6SPRM.

-1 is displayed for NOINLINE.
0 is displayed for default value.

Field Name: QWP4S1IL


Update 16
Date of change: April 2015
Topics: Multiple
Change description: PI33401 and additional field update:

The following field descriptions have been modified (QISTWFRHIG and QISTWFRCUR) in:

  • Chapter 40. IFCID Record Blocks -> "IFCID 002 - Data Manager Data":

    CUR RIDLIST BLOCKS OVERFLOWED
    This field is currently not set by DB2.
    Field Name: QISTWFRCUR

    MAX RIDLIST BLOCKS OVERFLOWED
    This field is currently not set by DB2.
    Field Name: QISTWFRHIG

  • Chapter 49. Statistics Report and Trace Blocks ->"RID List Processing":

    MAX RID BLOCKS OVERFLOWED
    This field is currently not set by DB2.
    Field Name: QISTWFRHIG

    CURRENT RID BLOCKS OVERFL.
    This field is currently not set by DB2.
    Field Name: QISTWFRCUR


Additional field update -> field name: QBSPGRS in:

Update 15
Date of change: February 2015
Topics: Multiple
Change description: PI32994

The information in the following sections has been updated:
Chapter 5. Accounting Default Layouts:
• Distributed Activity Server (Short Report)
• Distributed Activity Requester (Short Report)

In V5.2.0 or prior to this version the Short report of "Distributed Activity Server" or "Distributed Activity Requester" might show several data lines with the same requester name (or server name). In this case each separate data line refers to an individual product ID and product version. However, the default Short layout currently does not show the following fields: Product ID or Product Version.

Note: The total values for each requester (or server) are not calculated if there are multiple lines that result from different product IDs and product versions.
However, you can calculate these totals as follows:

  1. Field labels that start with a #-sign are totals. The sums of these fields are the values for each requester (or server).
  2. The remaining numerical fields are averages for each #DDFS. Multiply the shown average values by the #DDFS value to calculate the absolute value for each requester (or server) and line.
  3. Then summarize all absolute values for each requester (or server) and line, and divide the sum by the sum of all #DDFS values for each requester (or server).

You can customize the report layout using the user-tailored reporting (UTR) facility as described in the Reporting User's Guide section about “Tailoring report layouts”.
For Short layouts, for example, you can add the Product ID field to the Short report.

Note: The Product ID is already shown in the default Accounting Long reports:
◦ Distributed Activity – Requester (Long Report)
◦ Distributed Activity - Server (Long Report)
You can customize the Long report by adding the Product Version field using the user-tailored reporting (UTR) facility.


Update 14
Date of change: January 2015
Topics: Multiple
Change description: PI28338

The information in the following sections are new or updated for simulated buffer pool data:



Update 13
Date of change: September 2014
Topics: Multiple
Change description: The following field description has been modified: Q8STDSKU

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
Date of change: August 2014
Topics: Multiple
Change description: PI22243

The following information has been updated in the accelerator sections:



Update 11
Date of change: June 2014
Topics: Multiple
Change description: 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
Date of change: June 2014
Topics: Multiple
Change description: PI12870

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
Date of change: May 2014
Topics: Multiple
Change description: PI14759
The description of Aggregated Accounting records for Statistics has been added to:



Update 8
Date of change: May 2014
Topics: Multiple
Change description: PI16762

The following information has been updated and added:


Update 7
Date of change: April 2014
Topics: Multiple
Change description: PI09581

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
Date of change: April 2014
Topics: Multiple
Change description: PI12538

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
Date of change: March 2014
Topics: Multiple
Change description: PI08288

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
Date of change: February 2014
Topics: Multiple
Change description: PM99308

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
Date of change: December 2013
Topics: Multiple
Change description: PM98092

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
Date of change: December 2013
Topics: Multiple
Change description: PM99280

-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
Date of change: November 2013
Topics: Multiple
Change description: PM99040

-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



Publication number

SH12-6991

Copyright date

1985, 2017

Original publication date

2013/10/25

Product Alias/Synonym

OMEGAMON XE for DB2 PE
OMEGAMON XE for DB2 PM

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: 28 June 2017


Translate this page: