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
Start of changeAdds 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.End of change Start of changePH26293End of change
Start of changeAdds 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.End of change Start of change-End of change
Start of changeUpdates the Statistics - DBM1 and MVS Storage Below 2 GB sample layout. For more information, see DBM1 and MVS Storage Below 2 GB.End of change Start of change-End of change
Start of changeUpdates the IFCID 106 - Miscellaneous installation parameters sample report. For more information, see IFCID 106 - Miscellaneous installation parameters.End of change Start of change-End of change
Start of changeAdds IDAA InSync metrics to Accelerator Statistics overview and detail panels. For more information, see Accelerator Statistics Overview and Accelerator Statistics Detail.End of change Start of change-End of change
Start of changeAdds IDAA InSync metrics to Accelerator Statistics overview and detail panels. For more information, see Accelerator Statistics Overview and Accelerator Statistics Detail.End of change Start of change-End of change
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:
  • RESOURCE LIMIT STATIC ERROR ACTION (RLFERRSTC)
  • RLF REMOTE DYNAMIC ERROR ACTION (RLFERRD)
  • RLF REMOTE STATIC ERROR ACTION (RLFERRDSTC)
For more information, see Install DB2 - Resource Limit Facility (DSNTIPO4) (DB2 12).
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