IBM Support

PH11059: DB2PE REPORTS A VERY LARGE VALUE FOR IDAA MEMORY AVAILABLE FOR USER DATA.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2PE statistics report and trace as well as record trace for
    IFCID 002 may report a very large value for the field MEMORY
    AVAILABLE - USER DATA (MB) in their respective accelerator
    sections. This is caused by a value of -1 in the source Q8STTMUD
    field in the IFCID 002 record, meaning that the data was not
    collecected when the IFCID 002 record was generated. Because
    Q8STTMUD is defined as unsigned in the DSNDQ8ST macro, the -1
    value is not recognized and is processed as (2**64)-1, which
    causes the reported value to be incorrect. The inaccurate value
    
    
    may also be propagated to the DB2PM_STAT_ACCEL table in the
    performance data base (PDB) in column TOTAL_MEM_USERDATA.
    

Local fix

  • apply PTF when available
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
    *                 users of component                           *
    *                    -    Batch Reporter                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2PE STATISTICS REPORT and TRACE       *
    *                      as well as RECORD TRACE for             *
    *                      IFCID 002 may report a very large       *
    *                      value for the field                     *
    *                      "MEMORY AVAILABLE - USER DATA (MB)"     *
    *                      in their respective accelerator         *
    *                      sections.                               *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    DB2PE STATISTICS REPORT and TRACE as well as
    RECORD TRACE for IFCID 002 may report a very large value
    for the field "MEMORY AVAILABLE - USER DATA (MB)"
    in their respective accelerator sections.
    This is caused by a value of -1 in the source Q8STTMUD
    field in the IFCID 002 record, meaning that the data
    was not collected when the IFCID 002 record was generated.
    Because Q8STTMUD is defined as unsigned in the DSNDQ8ST
    macro, the -1 value is not recognized and is processed as
    (2**64)-1, which causes the reported value to be incorrect.
    

Problem conclusion

  • The Batch Reporter code was changed to recognize the Q8STTMUD
    variable as signed and display correct values for the field
    "MEMORY AVAILABLE - USER DATA (MB)" in the STATISTICS REPORT and
    TRACE as well as in RECORD TRACE for IFCID 002.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH11059

  • Reported component name

    OM XE DB2PE/PM

  • Reported component ID

    5655OPE00

  • Reported release

    540

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-04-15

  • Closed date

    2019-07-12

  • Last modified date

    2019-08-01

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

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

    UI64182

Modules/Macros

  • DGONF8ST DGOSPREP
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R540 PSY UI64182

       UP19/07/14 P F907

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

Document Information

Modified date:
01 August 2019