IBM Support

PK76396: Enhancement for IFCID 22 RECTRACE and SQLACTIVITY TRACE OUTPUT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • The field for value "COST" (QW0022OS) will be displayed with a 2
    digit decimal precision. It was displayed without decimal
    precision before. IFCID22
    
    SQL ACTIVITY
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
    *                 users of component:                          *
    *                 -   Batch Reporting                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: The RECTRACE output for IFCID 22 is not *
    *                      accurate enough as the value is a FLOAT *
    *                      and the report does not show any        *
    *                      decimal positions.                      *
    *                      The same is true for the SQLACTIVITY    *
    *                      TRACE containing IFCID 22 information.  *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply this PTF                               *
    ****************************************************************
    PROBLEM SUMMARY:
    The RECTRACE output for IFCID 22 is not accurate enough as the
    value is a FLOAT and the report does not show any decimal
    positions.
    The same is true for the SQLACTIVITY TRACE containing IFCID 22
    information.
    
    PROBLEM CONCLUSION:
    The formatting logic of the Reporter has been enhanced to
    include two decimal positions when formatting QW0022OS ("COST")
    for display in the RECTRACE TRACE and SQLACTIVITY TRACE report
    sets.
    

Problem conclusion

Temporary fix

Comments

  • The formatting logic of the Reporter has been enhanced to
    include two decimal positions when formatting QW0022OS ("COST")
    for display in the RECTRACE TRACE and SQLACTIVITY TRACE report
    sets.
    
    KEYWORDS :    QW0022OS RECTRACE SQLACTIVITY TRACE
    

APAR Information

  • APAR number

    PK76396

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    410

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2008-11-26

  • Closed date

    2008-11-27

  • Last modified date

    2011-02-18

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

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

    UK41860

Modules/Macros

  • DGONF023 DGORPMIN
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R410 PSY UK41860

       UP08/11/28 P F811

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

Document Information

Modified date:
18 February 2011