IBM Support

PI93288: COLUMN CL7_ELAPSED_LAST IN PDB TABLE DB2PMSACCT_PROGRAM TABLE MAY CONTAIN AN UNREALISTICALLY LARGE VALUE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Column CL7_ELAPSED_LAST in Performance Database (PDB) table
    DB2PMSACCT_PROGRAM table may have a value that is clearly
    incorrect in some rows. This happens when the value of either of
    the QPACSCB (Beginning Store Clock Time) or QPACSCE (Ending
    Store Clock Time) fields in the source accounting record (IFCID
    147, 148 or 239) is null.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM users of       *
    *                 Accounting PDB table DB2PMSACCT_PROGRAM.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: Column CL7_ELAPSED_LAST in PDB          *
    *                      table DB2PMSACCT_PROGRAM table          *
    *                      may contain an unrealistically          *
    *                      large value.                            *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    Column CL7_ELAPSED_LAST in Performance Database (PDB)
    table DB2PMSACCT_PROGRAM table may have a value that
    is clearly incorrect in some rows. This happens when
    the value of either of the QPACSCB (Beginning Store
    Clock Time) or QPACSCE (Ending Store Clock Time) fields
    in the source accounting record (IFCID 147, 148 or 239)
    is null.
    

Problem conclusion

  • The reported problem was fixed. Column CL7_ELAPSED_LAST
    will be set to zero if valid elapsed time cannot be
    calculated for any reason.
    
    Search Keywords:
    CL7_ELAPSED_LAST DB2PMSACCT_PROGRAM
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI93288

  • 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

    2018-02-02

  • Closed date

    2018-03-07

  • Last modified date

    2019-03-18

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

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

    UI54334

Modules/Macros

  •    DGOAFPCK DGOAREDP DGOARXIT DGOMTPKG DGOVSCT2
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R540 PSY UI54334

       UP18/03/10 P F803

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0"}]

Document Information

Modified date:
30 March 2021