PM35052: After UK65412 SMP/E ACCEPT fails with IEW2230S and BIND fails for EXPLAIN function with inconsistent DBRM

Obtain the fix for this APAR.

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 UK65412
  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 PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  See Problem Conclusion of PM35049
  
  PROBLEM CONCLUSION:
  See Problem Conclusion of PM35049
  

Problem conclusion

• See Problem Conclusion of PM35049
  
  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
  
  
  KEYWORDS : SMP/E ACCEPT BIND EXPLAIN
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK65933

Modules/Macros

•    DGO@TPL3 DGO@TPL4 DGOYTPL3 DGOYTPL4
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK65933

     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.