IBM Support

PH55987: AVOID DB2 SORT RELATED MEMORY OUTAGES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • To avoid memory outage issues when Db2 HPU invokes Db2 Sort, it
    should exploit the capability to request Db2 Sort to reserve
    memory to the caller brought by APAR PH55226.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload for     *
    *                 z/OS                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: To avoid memory outage issues when Db2  *
    *                      HPU invokes Db2 Sort, it should         *
    *                      exploit the capability to request Db2   *
    *                      Sort to reserve memory to the caller    *
    *                      brought by APAR PH55226.                *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    avoid Db2 Sort related memory outages
    

Problem conclusion

  • Code has been changed to fix this problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH55987

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-07-25

  • Closed date

    2024-01-02

  • Last modified date

    2024-02-01

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

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

    UI94999

Modules/Macros

  • INZ$$PRM INZTDSC  INZTVAR  INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R510 PSY UI94999

       UP24/01/04 P F401

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"510","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 February 2024