Product Documentation
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":
- Chapter 49. Statistics Report and Trace Blocks ->"RID List Processing":
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
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:
- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Simulated Buffer Pool Activity"
- Chapter 49. Statistics Report and Trace Blocks -> "Simulated Buffer Pool Statistics"
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:
- Field labels that start with a #-sign are totals. The sums of these fields are the values for each requester (or server).
- 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.
- 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:
- Chapter 40. IFCID Record Blocks -> "IFCID 002 - Simulated Buffer Pool Activity" (new)
(see Update 16* in PI33401 and additional field update) - Chapter 40. IFCID Record Blocks -> "IFCID 201 - Alter Buffer Pool"
- Chapter 40. IFCID Record Blocks -> "IFCID 202 - Buffer Pool Attributes"
- Chapter 49. Statistics Report and Trace Blocks -> "Simulated Buffer Pool Statistics" (new)
(see Update 16* in PI33401 and additional field update) - Chapter 55. Alter Buffer Pool Command Issued
- Chapter 57. Buffer Pool Parameters
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:
- 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 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.
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.
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:
- Chapter 50. "The Statistics Save-File Utility" --> "Converting Data Sets"
- Chapter 51. "The Statistics File Data Set and Output Records"
Update 8
Date of change: May 2014
Topics: Multiple
Change description: PI16762
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 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:
-Chapter 5. Accounting Default Layouts -> "Package Identification - Trace" :
The following information is updated:
-Chapter 5. Accounting Default Layouts -> "Package General (Short Report)" :
The following information is updated:
-Chapter 40. IFCID Record Blocks -> "IFCID 239 - Package/DBRM Accounting Data":
The following information is updated:
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:
-Chapter 49. Statistics Report and Trace Blocks -> "DBM1 Storage Above 2 GB" :
The following information is updated:
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:
-Chapter 5. Accounting Default Layouts -> "Query Parallelism":
-Chapter 5. Accounting Default Layouts -> "Service Units" :
-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:
- 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 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"
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"
- 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 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:
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:
Publication Number
SH12-6991
Copyright Date
1985, 2017
Original Publication Date
25 October 2013
Document Location
Worldwide
Product Synonym
OMEGAMON XE for DB2 PE;OMEGAMON XE for DB2 PM
Was this topic helpful?
Document Information
Modified date:
26 September 2022
UID
swg27040297