IBM Support

PM68500: STATEMENT SERVER EXECUTION METRICS ARE NOT SHOWN IN EXTENDED INSIGHT ANALYSIS DETAILS DASHBOARD

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Due to a metadata mismatch in the Repository Server database,
    the statement server side metrics collected from IFCID 316 and
    401 are not stored properly, thus resulting in empty detail
    screens.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Repository Server (OPM)                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The metrics collected from OMPE are not *
    *                      displayed in the Extended Insight       *
    *                      Analysis Dashboard, only client side    *
    *                      metrics are displayed.                  *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    The DB2 metrics collected from OMPE are not displayed
    in the Extended Insight Analysis Dashboard, only client
    side metrics are displayed. The inserts into the
    Repository Server PERFDB do fail for the server metrics,
    thus causing no data to be stored. See IC84077 for the
    detailed error message.
    
    PROBLEM CONCLUSION:
    By downloading and installing the software indicated in the
    TechNote, you will be able to see Statement Server Execution
    metrics again.
    

Problem conclusion

  • By downloading and installing the software indicated in the
    TechNote, you will be able to see Statement Server Execution
    metrics again.
    
    KEYWORDS : EXTENDED INSIGHT ANALYSIS
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM68500

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    511

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-10

  • Closed date

    2012-07-12

  • Last modified date

    2012-08-09

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

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

    UK80249

Modules/Macros

  • FPEO$INF
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R511 PSY UK80249

       UP12/07/17 P F207

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.1","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.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 August 2012