What's new in previous editions
This topic summarizes previous significant changes to the OMEGAMON for Db2 PE documentation.
Note: For a list of the most recent updates, see New and changed functions.
Documentation updates - 2024
| Description | Related APARs |
|---|---|
| Adds support for using the FIND command to search DSNZPARMS and SQL counters in data sharing groups in the enhanced 3270 user interface. | PH63255 | UI99473 |
| Adds new message: | PH63744 | UI99173 |
| Adds support for up to 64 active traces. | PH62541L | UI98867 |
| Removes EDM pool fields QISEDFRE, QISECFRE, and QISEKFRE from the KDPEDMN workspace in the enhanced 3270 user interface. | PH58016 | UI95509 |
Updated Workspace names and descriptions to include new and
updated workspace:
|
PH61547 | UI98612 |
| Adds support for Package Details in enhanced 3270UI Thread History. | PH61547 | UI98612 |
Updated Workspace names and descriptions to include new workspace:
|
PH61547 | UI98612 |
| Adds new fields to TEP Client: | PH60055 | UI97587 |
Removed deprecated parameters from the System
Parameters report and Performance Database (PDB) tables:
|
PH57910 | UI96266 |
Updated reports:
|
PH57910 | UI96266 |
Updated Workspace names and descriptions to include new workspace:
|
PH57910 | UI96266 |
Previous updates - 2023
| Description | Related APARs |
|---|---|
| Adds new fields to IFCID 001 - Db2 Command Data: | PH54751 | UI93655 |
| Adds support for Application Trace Facility (ATF) in the enhanced 3270 user interface to trace the execution of a Db2 application: Adds new fields to TEP Client: | PH55939 | UI95090 + UI95091 |
| Adds new fields to IFCID 225 - Address Space Summary - DIST: | PH54751 | UI93655 |
| Adds IFCID 411 and IFCID 412 statistics support: | PH53163 | UI92482 |
| Adds fields to TEP Client: | PH51040 | UI91411 |
Previous updates - 2022
| Description | Related APARs |
|---|---|
| Adds Batch ACCOUNTING support: | PH48556 | UI90100 |
| Updated report: | PH46427 | UI83049 |
| Adds IRLM batch statistics support: | PH48556 | UI90100 |
| Adds PACKAGE DEPENDENCY LEVEL field (PACKAGE_DEPENDENCY_LEVEL subsystem parameter) support: | PH48556 | UI90100 |
| Adds new fields to TEP Client: | PH46427 | UI83049 |
| Adds two new Take Action commands: | PH48556 | UI90100 |
| Adds new fields to Record Trace - IFCID 001 - Log Manager Data: | PH48556 | UI90100 |
| Updated reports: | PH48556 | UI90100 |
| Adds new fields to TEP Client: | PH48556 | UI90100 |
| Adds location statistics details table (containing data from the QLST section of IFCID 365): | PH46427 | UI83049 |
| Adds two new fields, POOLINAC and Reuse Limit, to TEP Client: | PH46145 | UI80688 |
| Adds new fields to TEP Client: | PH46145 | UI80688 |
| Updates Db2 13 function level support information. For more information, see Db2 function level support. | - |
| New or updated messages: | PH46427 | UI83049 |
| New or updated messages: | PH43371 | UI79511 |
| Adds information about how to use Application Transparent Transport Layer Security (AT-TLS) to secure communications between the OMEGAMON Db2 Collector PE Server subtasks and Performance Expert Client (PE Client). For more information, see Configuring AT-TLS encryption. | PH46427 | UI83049 |
| Updated report: | PH42014 | UI80149 |
Updated reports:
|
PH46359 | UI81538 |
|
Parameter enhancements |
PH46145 | UI80688 (prerequisites OA62832 | UJ08515 from HKCI310 FMID) |
|
RETRACE enhancements Adds RECTRACE support for QLLL:
Adds Batch RECTRACE support:
Adds support for QDST changes in RECTRACE:
Adds Batch ACCOUNTING support:
|
PH46145 | UI80688 (prerequisites OA62832 | UJ08515 from HKCI310 FMID) |
Adds support for Db2 system profile monitoring in enhanced 3270
user interface:
|
PH46145 | UI80688 (prerequisites OA62832 | UJ08515 from HKCI310 FMID) |
Adds new fields to TEP Client:
|
PH46145 | UI80688 (prerequisites OA62832 | UJ08515 from HKCI310 FMID) |
| Updated information on how to set up your environment for Performance Warehouse: | PH46145 | UI80688 (prerequisites OA62832 | UJ08515 from HKCI310 FMID) |
Updated Workspace names and descriptions to include
new workspaces:
|
PH46145 | UI80688 (prerequisites OA62832 | UJ08515 from HKCI310 FMID) |
Previous updates - 2021
| Description | Related APARs |
|---|---|
| Discarded storage metrics introduced with Db2 APAR PI82191/PI78979 are externalized in the Record Trace and Statistics reports and also reported as a columns in Statistics PDB tables and CSV output: | |
|
Implements RECTRACE changes:
|
|
| Adds information about Take Action security requirements. For more information, see: | - |
| Clarifies features supported by ISPF Monitor. For more information, see About ISPF Online Monitor. | - |
| Clarifies the usage of the STOP command. For more information, see Subtask commands to Performance Expert Server. | - |
| Adds information about create a secure JDBC connection from your PE Client to Performance Warehouse For more information, see Creating secure JDBC connections for Performance Warehouse. | - |
| Updated the Parameters section to improve topic organization and navigation. | - |
| Updates default values for several periodic exception processing parameters. For more information, see: | - |
| Adds COPT and Data Set tabs to thread history in the enhanced 3270 user interface. For more information, see Viewing thread history. | PH37183 |
| Adds the DMSTAT (Data Manager Statistics KDPSQLF) tab to the enhanced 3270 user interface. For more information, see Viewing system statistics. | PH37183 |
| Adds new zParms to the DSNZPARM panels in the Classic User Interface and to the corresponding tabs of the DSNZPARM Thread Parameters panel in the enhanced 3270 user interface. For more information, see: | PH37183 |
| Corrected information about the START subtask command. For more information, see OMEGAMON Collector subtask commands. | - |
| Adds information about the .LOGON and .LOOFF commands. For more information, see OMEGAMON Commands. | - |
| Adds batch RECTRACE support for new fields in the QIST and QWSA data sections that are mapped by IFCID 1,2 reports. For more information, see: | PH38004 |
| PDB/CSV support is added for fields introduced with Db2 APARs PI92652, PH22516, PI81731, PH29098, PH27493, PH31684, PI72330. | PH38004 |
| New Db2 fields enabled by Db2 FL509 are now externalized to Accounting PDB tables and CSV field selection lists. | PH33376 |
| Enhanced QLST metrics enabled by Db2 APAR PH16111 are now externalized to Record Trace PDB tables and CSV field selection lists. | - |
| Adds a clarification of the effects of recycling a Db2 subsystem on snapshot history processing. For more information, see PE Client considerations. | - |
| Adds information about enabling interval statistics in Snapshot History. For more information, see Enabling interval statistics and Reset procedure (situation). | - |
| Updates batch reports for Db2 Currency. For more information, see IFCID 096 - Sort End, IFCID 002 - SQL Call Data, IFCID 002 - Miscellaneous, IFCID 002 - Service Controller Data, and IFCID 002 - Data Manager Data. | - |
| Activity type value is now reported as a column in the Accounting SAVE-FILE PDB tables and CSV output generated from Accounting SAVE-FILE. | - |
| ACE value is now reported as a column in Accounting FILE PDB tables and CSV output generated from Accounting FILE. | PH33376 |
| A new sample JCL KO2INCAP has been added to TKO2SAMP for formatting NTH or E3270UI Thread history VSAM data set before they are used by the OMEGAMON Collector. For more information, see Starting NTH data collection. | - |
| Adds information about the Thread SQL Statement Text Workspace. | - |
| Adds new fields that show Analytics Accelerator and delay protocol metrics. For more information, see Thread Accelerator Information attributes. | PH33376, PH29650 |
| Adds new fields that show zHyperlink metrics. For more information, see Db2 Buffer Pool Statistics attributes, Db2 Thread Detail Buffer Pool attributes, and Db2 Thread Class 3 attributes. | PH33376, PH29650 |
| Adds new fields that show interval statistics metrics. For more information, see Interval Statistics attributes. | - |
| Adds mention of the Cancel Thread in DSG option to the Data Sharing Thread Activity Workspace. | - |
| Db2 Interval Statistics field added to Table 2. Workspace and attribute cross reference for history collection for Db2 subsystems. For more information, see Enabling historical data collection. | - |
| Expands and updates the content in the Completing the configuration section. | - |
| The ranges for TLAD KPI tolerances have been adjusted to allow for higher upper levels. For more information, see: | - |
| Updates Db2 12 function level support information. For more information, see Db2 function level support. | - |
| Updates Record trace - IFCID 045 - Lock Resume. For more information, see IFCID 045 - Lock Resume. | PH28824 |
| Updates field descriptions for Accelerator Statistics Attributes. For more information, see Accelerator Statistics attributes. | PH33881 |
| CICSTRAN filter in ATF uses CORRID filter for respective trace request. For more information, see Specify Application Trace. | - |
| Updates LOCKING TRACE TIMEOUT report. For more information, see Lockout Trace. | PH33881 |
| 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 Using Anomaly Detection, KO2A - Anomaly Detection Messages, and KD2_PFnn_HIS_AD - Anomaly detection. | 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. | PI95808 |
| Adds support for unqualified table in SQLPA. For more information, see IFCID 045 - Lock Resume and Enabling options in OMEGAMON for Db2 PE Collector Realtime Customer Options (OMPEOPTS). | PH25623 |
| 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. | - |
| New or updated messages: | - |
| New or updated messages: | - |
| New or updated messages: | PH35707 |
| New or updated messages: | - |
| New or updated messages: | PH26293 |
Previous updates - 2020
| Description | Related APARs |
|---|---|
| Adds fields for thread details for HTAP metrics. For more information, see IFCID 365 - Remote Location Statistics. | - |
| Adds new fields for Accelerator Data. For more information, see Accelerator Data - Version 4 or later. | PH23077 |
| Adds new IFCID 225 fields. For more information, see Address Space Summary and Shared and Common Storage. | PH22867 |
| Adds latch counters, IRLM counters, and SQL counts to statistics displays in enhanced 3270 user interface and Classic User Interface. For more information, see RID List Processing and IFCID 002 - Data Manager Data. | PH17426 |
| Adds information about new zHyperLink related fields for the batch interface. For more information, see Buffer pool report and trace and Package buffer pool activity - Class 10. | PH16135 |
| Adds new Db2 V12 ZPARM fields for the enhanced 3270 user interface. For more information, see: | PH24496, PH14386 |
| Adds newly supported CICS releases and remove some older CICS releases to the CICS RELS field description. For more information, see: | PH12498 |
| New or updated messages: | PI99189, PH04689 |
| New or updated messages: | PH02763 |
| New or updated messages: | PI95385 |
| New or updated messages: | PH11516 |
| 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. | - |
| Updates NTH WRITEOPTION description. For more information, see WRITEOPTION - Near-term history data collection options keyword. | - |
| Adds information about thread detail HTAP metrics including Accum Wait Time for Delay Protocol and # Stmts Wait Delay Protocol Expired field descriptions. For more information, see Thread Accelerator Detail. | - |
| Adds IFCID 376 Type 11 field description. For more information, see IFCID 376 - Incompatible Functions Executed. | - |
| The Timestamp field on the Audit Trace and Audit Detail reports now uses the following format: MM/DD/YY HH:MM:SS:uu. For more information, see Field Descriptions (Audit Detail Report and Audit Trace) | - |
| New or updated messages: | - |
Previous updates - 2019
| Description | Related APARs |
|---|---|
| The integration of OMEGAMON for Db2
PE 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. IBM Db2 AI for z/OS integration is only valid for Db2 12 subsystems. For more information, see: |
PH12500 |
| New or updated messages: | PH12500 |
Updated the following field descriptions to
reflect proper range for the number of CPU service units allowed for
a query:
|
PH02595 |
| Adds 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 |