New and changed functions
This topic summarizes the recent enhancements and changes in OMEGAMON for Db2 Performance Expert.
General documentation updates - 2021-03-23
Description | Related APARs |
---|---|
Adds Anomaly Detection which uses a learning period to record metrics of thread executions and then evaluate subsequent Db2 threads against these learned metrics to look for anomalies. A Db2 thread that is outside the learned range by greater than the tolerance value is identified as an anomaly. Learning continues if the value is within a reasonable range based on the discard tolerance value. For more information, see About Anomaly Detection, KO2A - Anomaly Detection Messages, and Anomaly Detection parameters. | PH26293 |
Adds IDAA HTAP metrics to the relevant batch report reference topics. For more information, see Accelerator, IFCID 316 - SQL Statement Statistics, IFCID 401 - Static Statements in EDM Pool, and IFCID 003 - Accelerator Data. | - |
Updates the Statistics - DBM1 and MVS Storage Below 2 GB sample layout. For more information, see DBM1 and MVS Storage Below 2 GB. | - |
Updates the IFCID 106 - Miscellaneous installation parameters sample report. For more information, see IFCID 106 - Miscellaneous installation parameters. | - |
Adds IDAA InSync metrics to Accelerator Statistics overview and detail panels. For more information, see Accelerator Statistics Overview and Accelerator Statistics Detail. | - |
Adds IDAA InSync metrics to Accelerator Statistics overview and detail panels. For more information, see Accelerator Statistics Overview and Accelerator Statistics Detail. | - |
Updates NTH WRITEOPTION description. For more information, see WRITEOPTION - Near-term history data collection options keyword. | - |
Adds note regarding lading or FILE or SAVE data from different reports. For more information, see Creating data for the Performance Database and the Performance Warehouse. | - |
Adds fields for thread details for HTAP metrics. For more information, see IFCID 365 - Remote Location Statistics. | PH16111 |
Adds support for Db2 Location statistics (QLST extensions) in RECTRACE - OMPE Batch Reporting. See IFCID 365 - Remote Location Statistics. For more information, see Thread Accelerator Detail. | - |
Adds IFCID 376 Type 11 field description. For more information, see IFCID 376 - Incompatible Functions Executed. | - |
Adds new fields to the OMPE Report Reference section for Accelerator Data. For more information, see Accelerator Data - Version 4 or later. | PH23077 |
General updates and improvements to the Planning, Customization, and Migration content. | - |
Adds new IFCID 225 fields. Address Space Summary and Shared and Common Storage. | PH22867 |
Adds latch counters, IRLM counters, and SQL counts to statistics displays in E3270 and Classic user interfaces. | PH17426 |
Adds information about new zHyperLink related fields for the batch interface. | PH16135 |
Adds new Db2 V12 ZPARM fields for FL505 support. The following panels have been updated:
|
PH24496 |
Adds new Db2 V12 ZPARM fields for the E3270 user interface. | PH14386 |
Adds newly supported CICS releases and remove some older CICS releases to the CICS RELS field
description. For more information, see: |
PH12498 |
Adds new thread and statement level HTAP metrics | PH15534 |
As of IBM® OMEGAMON for Db2 Performance Expert on z/OS V5.4, the Timestamp field on the Audit Trace and Audit Detail reports now uses the following format: MM/DD/YY HH:MM:SS:uu | – |
The integration of IBM OMEGAMON
for Db2 Performance
Expert on z/OS and IBM
Db2 AI for z/OS enables you to launch an IBM Db2zAI System Assessment from the Performance Expert
periodic and event exception detail displays, and in doing so helps you to determine the root cause
of problems. Note: IBM Db2 AI for z/OS integration is only valid for Db2 12 subsystems.
For more information, see: |
PH12500 |
Updated the following field descriptions to reflect proper range for the number of CPU
service units allowed for a query:
|
PH02595 |
Added SERVER ENCRYPT COMP and SECURE CONNECTION flags to the record trace IFCID 319 Audit Security Record. For more information, see IFCID 319 - Audit Security Record. | PH09361 |
You can now review buffer pool information (such as getpages and buffer pool hit ratios), to evaluate how well a thread is performing and to determine if excessive I/O is being consumed for a thread. For more information, see Accessing information about buffer pool performance. | PH03718 |
General edits and updates | – |
Restructured the lists of previous changes to OMEGAMON for Db2 Performance Expert. For more information, see What's new in previous editions | – |
Added list of links to additional documents (PDFs). For more information, see What's new in OMEGAMON for Db2 Performance Expert | – |
New and updated messages
Description | Related APARs |
---|---|
PH26293 | |
- | |
PI99189 | |
PH02763 | |
PH12500 | |
PI95385 | |
PH04689 | |
PH11516 | |
PI99189 | |
– |