A fix is available
APAR status
Closed as program error.
Error description
1. SMP/E SMPE ACCEPT check is successful for UK65412 but actual ACCEPT fails for object KO2ZZCC IEW2322I 1220 1 INCLUDE SMPWRK3(KO2ZZCC) UK65325 SEQ # 0 IEW2322I 1220 2 SETSSI 01115325 IEW2322I 1220 3 NAME KO2ZZCC(R) MAX ACCEPTABLE RC=08 IEW2230S 0414 MODULE HAS NO TEXT. IEW2650I 5102 MODULE ENTRY NOT PROVIDED. ENTRY DEFAULTS TO SECTION OMPEZCC. IEW2008I 0F03 PROCESSING COMPLETED. RETURN CODE = 12. 2. BIND fails for EXPLAIN component, EXPLAIN is unavailable DSNT231I -QSSA BIND DBRM ERROR USING IS6X AUTHORITY PACKAGE=HAMBURG_QSSA.KO2EX510.DGO@TPL3 DBRM DGO@TPL3 IS IN AN INCONSISTENT STATE DSNT231I -QSSA BIND DBRM ERROR USING IS6X AUTHORITY PACKAGE=HAMBURG_QSSA.KO2EX510.DGO@TPL4 DBRM DGO@TPL4 IS IN AN INCONSISTENT STATE This effects the following APAR / PTF => PEing APAR combinations PM24083 / UK65325 => PM35049 PM32638 / UK65399 => PM35051 PM32647 / UK65412 => PM35052
Local fix
1. Do not ACCEPT UK65325 2. n/a
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 * * * * In addition this PTF solves an SMP/E * * ACCEPT issue and a BIND EXPLAIN issue. * * * **************************************************************** * RECOMMENDATION: Apply this PTFs * * * **************************************************************** See Problem Conclusion
Problem conclusion
COMMENT text fuer PM24083 im Retain **************************************************************** * 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 New versions for the following books are available on the DB2 Tools Library Page: http://www.ibm.com/software/data/db2imstools /db2tools-library.html#omegaxepe-lib (SH12-6927-01) Reporting User's Guide (SH12-6921-01) Report Reference (SH12-6924-01) Monitoring Performance from the OMEGAMON Classic Interface There are also TechDocs available for the following books. To access the TechDoc content for the specific book click on the link titled 'See updates to this Book!' for the corresponding book entry. (GH12-6928-00) Configuration and Customization (GH12-6923-00) Messages
Temporary fix
********* * HIPER * *********
Comments
×**** PE11/05/05 PTF IN ERROR. SEE APAR PM36528 FOR DESCRIPTION
APAR Information
APAR number
PM35049
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-03-17
Closed date
2011-03-18
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:
UK65924
Modules/Macros
HKDB510J KDB510J KO2ZZCC
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R510 PSY UK65924
UP11/03/24 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