IBM Support

PM39282: PERFORMANCE IMPROVEMENT FOR E2E STATEMENT TEXT RETRIEVAL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Under certain situations the buffer used to transfer the
    statement text data from the OMPE Collector to the Optim
    Performance Manager Extended Insight Statement Text collector is
    not used at its best. This development APAR maximises the
    buffer usage.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -  PE Server subtask                         *
    *                 -  End to End SQL Monitoring feature (V510+) *
    ****************************************************************
    * PROBLEM DESCRIPTION: Under certain situations the buffer     *
    *                      used to transfer the statement text     *
    *                      data from the OMPE Collector to the     *
    *                      Optim Performance Manager Extended      *
    *                      Insight Statement Text collector is     *
    *                      not used at its best.                   *
    *                      This APAR maximises the buffer usage.   *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    *                                                              *
    ****************************************************************
    PROBLEM SUMMARY:
    Under certain situations the buffer used to transfer the
    statement text data from the OMPE Collector to the Optim
    Performance Manager Extended Insight Statement Text collector
    Is not used at its best.
    
    PROBLEM CONCLUSION:
    The usage of the return area buffers has been optimised.
    

Problem conclusion

Temporary fix

Comments

  • The usage of the return area buffers has been optimised.
    
    KEYWORDS :    E2E TRACKER PERFORMANCE OPTIMIZATION
    

APAR Information

  • APAR number

    PM39282

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    510

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2011-05-16

  • Closed date

    2011-09-05

  • Last modified date

    2017-06-16

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

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

    UK71610

Modules/Macros

  •    DGOVMSTR DGOVSQFM FPEVRDS1
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R510 PSY UK71610

       UP11/09/07 P F109

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:
16 June 2017