A fix is available
APAR status
Closed as new function.
Error description
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - OMEGAMON collector * * - PE Server subtask * * - The component that transfers DB2 * * monitoring data collected by the * * OMEGAMON collector to the TEMA * * - Classic Interface * * - CUA Interface * * - Performance Expert Client * * - EXPLAIN * * - ICAT * * - Batch Reporting * * - Performance Database users * * - Performance Warehouse users * **************************************************************** * PROBLEM DESCRIPTION: Collection of new functionality and * * development fixes/enhancements * * * **************************************************************** * RECOMMENDATION: Apply this PTFs * * * **************************************************************** See Comments
Problem conclusion
Temporary fix
Comments
**************************************************************** * DESCRIPTION : * * * * NTH and zIIP * * * * With this PTF, when OMEGAMON DB2 PE/PM's Near-term * * History (NTH) component is activated for the DB2 * * subsystem(s) OMEGAMON is monitoring, NTH's data * * manager sub-component processing which is executed in * * enclave SRB mode will be directed to an available * * zIIP. NTH's data manager sub-component is responsible * * for normalizing raw DB2 instrumentation data from the * * multiple DB2 releases supported by OMEGAMON to a * * single, consistent format for processing. * * * **************************************************************** * * * Performance Database enhancements * * * * This PTF adds columns to ACCOUNTING FILE DDF, GENERAL and * * PROGRAM tables and changes column definitions of ACCOUNTING * * FILE BUFFER, GENERAL and PROGRAM tables (according to * * customer requirement MR0927106232 and related IBM Development* * APAR PM24756). * * See chapters 'Upgrading the Performance Database' in the * * 'Configuration and Customization' on how to migrate 'old' * * tables if you want to use the data in the new version. * * * **************************************************************** * * * Migration of Accounting and Statistics SAVE data sets * * * * This PTF adds the MIGRATE function of the Save-File Utility. * * See chapters 'The Accounting Save-File Utility' and 'The * * Statistics Save-File Utility' in the 'Report Reference' on * * How to migrate Accounting and Statistics Save data sets * * created by OMEGAMON XE for DB2 PE V4.1 or V4.2 into the * * record format of OMEGAMON XE for DB2 PE V5.1. * * * **************************************************************** * * * EXPLAIN enhancements * * * * 1. For DB2 V10 Conversion Mode there is a new sample part * * TKO2SAMP(FPEYCV0C) to create the VIEWs for Explain. * * The ICAT created part is RKD2SAM(EXC1&dbid). * * 2. The PLAN_TABLE report block in Batch-Explain has a new * * block layout. The block starts with "EXPLAIN TABLE:" * * and has 2 block columns. The report field labels are the * * full PLAN_TABLE column names. If the report field value * * is a long name or a long value, it is marked with an "*" * * at the end of the report field value, and reported at * * the end of the block in its full length. * * * **************************************************************** * * * PE Client * * * * Enable Static Statement Cache support in PE Client * * Statistics Details panel for DB2 10 * * * * * * PE Client field "Page Number within page set" in PE Client * * SQL Statement Thread Details panel is now shown as * * hexadecimal value as it can include the partition number. * * * **************************************************************** * Batch Reporting * * * * System Parameter QWP4METE (ZOSMETRICS) now shown in Batch * * Record Trace and System Parameter reports * * * * The HIGHLIGHT block in Batch ACCOUNTING LONG TRACE has been * * changed. It shows new field named QUANTITY. * * * * Batch Audit TRACE and REPORT supports new IFCID 271. Data * * related to objects ROW PERMISSION and COLUMN MASK are shown. * * * * The layout of a Batch SQL TRACE has changed in case a CLOSE * * event was processed. Additional fields are shown. * * * * Batch Record Trace Reporting supports new DB2 Version 10 * * instrumentation data: * * - New IFCIDs 370 and 371 (Dataset open and close activities) * * - New counter QBSTNSG in IFCID 2 (Buffer Pool Activity) * * - New statistic counters for Data sharing locking data * * (QTGSCREJ, QTGSFLGS) in IFCID 2 * * - New accounting counter for Data sharing locking data * * (QTGAFLSE) in IFCID 3 * * * * The report sections "DATA SHARING LOCKING DATA" in IFCID 2 * * and IFCID 3 have been changed to include these new counters. * **************************************************************** * * * More Near-Term History enhancements: * * * * 1. Improved precision in NTH CPU filter (MR0211082152) * * In VTAM panel ZHAFL (Thread History Filter Options) the * * precision that can be entered for the fields * * DB2-CPU-TIME, DB2-ELAP-TIME and IO-ELAP-TIME has been * * increased from one decimal position to six positions. * * * * 2. New cell pool memory management * * * **************************************************************** * * * Application Trace Facility Enhancement * * * * Support to display counters of new DB2 10 data section * * QW0058D in ATF panel ZATD1 for CLOSE CURSOR SQL calls. * * * **************************************************************** * * * New fields in VTAM Classic and Near Term History panels: * * * * Panel ZGLOK shows new field "Very Conditional Rejections" * * Panel ZHGLD shows new field "Very Conditional Rejections" * * Panel ZTGLOC shows new field "Total Number False Content." * * Panel ZHTGLOC shows new field "Total Number False Content." * * Panel ZBP shows new field "Getpage Failed - Cond SeqReq" * * Panel ZHBPD shows new field "Getpage Failed - Cond SeqReq" * * * **************************************************************** * * * ICAT * * * * Added support for DB2 v10 CM mode for EXPLAIN * * * **************************************************************** -------------------------------------------------------------- ICAT problems fixed and enhancements: - Fix for verification of volume label to allow volume names with a number at first character position - Fix for VOLSER/UNIT field problem when using 7 static sequential NTH data sets and PF3 on the configuration panel - Fix for missing DB2 v10 support for RTE that uses model RTE - Fix for comments and help section for DB2 v10 in Conversion Mode OMEGAMON Collector PE Server subtask problems fixed: - Fix for various abends 0C4, 04F and 42A if monitored DB2 subsystems are restarted or abnormally terminated while PE Server stays up and running. - Fix for abend 0C4 in load module DGOVHM00 if application summary data are requested for a DB2 Connect Gateway from the PE Client user interface - Fix for no statement text shown in ATF Static SQL Statement Text display and EDM Pool Static Statement Cache display for DB2 10 subsystems in Conversion Mode - Fix for memory leak in PE Server subtask load module FPEVDB2I if EDM Pool data are requested from the VTAM Classic interface for different monitored DB2 subsystems during switching of monitored DB2 subsystems. Near Term History related problems fixed: - High CPU in NTH when looking at distributed thread details (ZHTACT) - ZESSS EDMPool static statement cache has zero displayed for all time fields - DB2 RSN=00F30011 and 00C12219 causes dump in collector - ZHTACT high CPU loop when displaying a Distributed Allied Thread - NTH terminated after NEW OPTIONS with VSAMSEQ data collection - 0C4 abend when displaying NTH data set - incorrout on package summary and package detail panels - incorrout on various panels such as ZHGBS,ZHSMS,ZHSMD,ZHEDD - incorrout on various thread display panels such as ZHATBUF,ZHTACT - NTH will not terminate in some conditions due to recovery loop - accounting class could be missing from collection option panel ZH2IN Object Analysis problems fixed: - memory leak in SP 107 when using the Volume related Exceptions - Abend in LMOD=KO2ED01K#L,OFFSET=000B50 when stopping a DB2 Version 10 subsystem in Conversion Mode PE Client related problems fixed: - INCORROUTs when displaying monitoring data in Thread Summary, Thread Detail, Statistics Detail and System Parameters panels - INCORROUTs when displaying monitoring data from DB2 V8 and V9 subsystems - 0C4 abends in OMEGAMON Collector PE Server subtask when requesting DB2 V8 and V9 data Batch Reporting related problems fixed: - INCORROUTs during SAVE/MIGRATE processing for Batch Accounting and Statistics Data - INCORROUT in DBM1 STATISTICS report block - INCORROUTs when processing V8/V9 SMF and DPMOUT data in Batch Reporting - INCORROUTs in Record Trace batch reports VTAM Classic Interface problems fixed: - 0C4Abend in $FND9800 - ZPTDTL OB0910: Program Check - Recovery Successful-OHIL+020A - ZDBACT program check when thread is a Distributed Allied Thread - Missing child threads from CICS/IMS display - Incorrect thread DB2 status - PLNTOBJ 0C4 abend when DB2 ACE is invalid - Incorrect field display on ZBP - TCPNAME can no longer be overridden using IPNAME OMPEOPTS option - OB0532 "Response" invalid PPRF command from ZFILT panel - Thread CPU related program checks KO2CDB2K#L - Issues processing OMEGAMON Collector Routing table - Missing stored procedure threads when zoom on one WLM address space - Various VTAM exception rule related fixes - Various abends due to multiple RLOG or info line switches - Exception highlighting issues - Incorrout from various VTAM panels (ZSQL, ZDALLT, ZINACT, ZALLT, ZLOCKC, ZLOGM, ZTDTL, ZBPSF, ZPKD, ZBUF, ZTRACED, ZPCTL, ZTCNO, ZDFVS, ZDFST, ZPKG) - Incorrout on panel ZSYSPT - wrong number and type of threads shown - 0C4 abend in KO2ODB2F THSTAT02 call due to memory overlay, U0195 KO2OCNTB#L+18C70 Application Trace Facility problems fixed: - program checks from ZATRD and ZATD1 panels - ZATD3: END of SCAN event Missing DB/PS translation for CICS transactions. - no stop trace command is issued after ATF is stopped for DB2 V8 subsystems - 0C4 abend in KO2ACAF* load module due to DB2 Version 10 EANC control block moved above the bar CUA interface related problems fixed: - current NTH status is not obtained properly in CUA ... ×**** PE11/03/17 FIX IN ERROR. SEE APAR PM35049 FOR DESCRIPTION
APAR Information
APAR number
PM24083
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2010-10-07
Closed date
2011-03-01
Last modified date
2017-02-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DGOFECAL DGOFECHK DGOFEDAT DGOFEDPM DGOFEPKG DGOFSBGL DGOFSBST DGOFSDLT DGOFSDST DGOFSISE DGOFSIST DGOFSJST DGOFSLST DGOFSSST DGOFSTGS DGOFSTST DGOFSTXA DGOFSVLS DGOFSWSA DGOFSWSB DGOFSWSC DGOFSWSD DGOFSXST DGOFS254 DGOFS3ST DGOFS9ST DGOFUFAC DGOFUFDI DGOMEFXF DGOMEXA1 DGOMEXA3 DGOMFTAG DGOMGRDP DGOMSBCD DGOVABAN DGOVCCP DGOVCRDB DGOVDB2F DGOVDMSG DGOVEEDR DGOVEEDS DGOVEE00 DGOVEE01 DGOVFTAB DGOVFTIN DGOVHMDR DGOVHMM0 DGOVHMM1 DGOVHMM2 DGOVHMS1 DGOVISI DGOVMDSP DGOVMIDI DGOVMSTR DGOVMUAE DGOVM002 DGOVPIG1 DGOVPMOV DGOVPP0 DGOVPP1 DGOVPP2 DGOVPP3 DGOVPP4 DGOVPP5 DGOVRA DGOVRSFI DGOVRTG1 DGOVSADJ KO2ZSRB KO2ZSSI KO2ZSTK KO2ZSTO KO2ZSTS KO2ZSUB KO2ZSVC KO2ZSVS KO2ZSVU KO2ZTKN KO2ZTMR KO2ZTOP KO2ZTRC KO2ZTRM KO2ZUCM KO2ZUTL KO2ZVAL KO2ZVAT KO2ZVCB KO2ZVCS KO2ZVCZ KO2ZVLS KO2ZVTB KO2ZV64 KO2ZWTO KO2ZXCB KO2ZXCF KO2ZXCM KO2ZXCQ KO2ZXCT KO2ZXDQ KO2ZXGP KO2ZXIO KO2ZXMT KO2ZXNO KO2ZXPC KO2ZXQR KO2ZXRB KO2ZXRD KO2ZXRE KO2ZXRM KO2ZXRR KO2ZXRS KO2ZXRT KO2ZXSN KO2ZXST KO2ZXVR KO2ZXYZ KO2ZZCC KO2ZZIP KO2ZZPC KO2ZZPN KO2ZZPP KO2ZZPS KO2ZZPT KO2ZZRM KO2ZZRR KO2ZZSL KO2ZZSM KO2ZZSR KO2ZZTM KO2ZZ64
| SH12692701 | SH12692101 | SH12692401 |
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R510 PSY UK65325
UP11/03/16 P F103
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 February 2017