IBM Support

PH24996: FIELD_QUAL_ACTUAL IN TABLE DB2PM_EXCEPTIONS HAS WRONG VALUE IN SOME CASES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • FIELD_QUAL_ACTUAL in table DB2PM_EXCEPTIONS has wrong value in
    some cases
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: - PDB                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: The value in column FIELD_DUAL_ACTUAL   *
    *                      of the table DB2PM_EXCEPTIONS is        *
    *                      always BP0 regardless what field it is. *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    Workarea does not cleaned up, so old value is kept for all
    fields which have no qualification values.
    

Problem conclusion

  • Workarea was cleaned up to prevent put previous values
    in actual record.
    
    Search Keywords:
    DB2PM_EXCEPTION TABLE FIELD_QUAL_ACTUAL COLUMN PERMANENT VALUE
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH24996

  • 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

    2020-05-04

  • Closed date

    2020-07-20

  • Last modified date

    2020-08-03

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

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

Modules/Macros

  • DGOFEDPM DGOVMSTR DGOZBEXP DGOZPC2  DGOZSQPA KD5AGENT KDPATR
    KDPBAR   KDPCAT   KDPDOC   KDPDSEXP KDPDSQLS KDPHDSQL KDPJSTMS
    KDPJSTPS KDPJSTPW KDPMAP   KDPMSMAN KDPPLEX  KDPVRTMS KO25DSQL
    KO2APC72 KO2APC7K KO2APC7S KO2OSQPB
    

Fix information

  • Fixed component name

    OM XE DB2PE/PM

  • Fixed component ID

    5655OPE00

Applicable component levels

  • R540 PSY UI70644

       UP20/07/22 P F007

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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 August 2020