IBM Support

PH53039: INCORROUT WHEN UNLOADING FROM NON REFERENCE IMAGE COPY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The data unloaded from an image copy is incorrect. Some expected
    records can be missing from the unloaded data and/or the content
    of some unloaded records is incorrect. This can occur if all the
    following conditions are fulfilled:
    - the data is unloaded from an image copy or a set of image
    copies (COPYDDN option)
    - the input Image Copy is sorted by Db2 HPU before the unload as
    requested by the INLINE or FROM_COPYTOCOPY, MERGE_IIC option or
    because Db2 HPU determined a sort was needed for the input image
    copy (COPYDDN ddname, CHECK option or COPYDDN LAST_IC/- integer
    option)
    - the image copy or the set of image copies contains several
    occurrence of the same tablespace page, one with RBA set to 0
    and other pages with non zero RBAs.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload         *
    *                 for z/OS                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: The data unloaded from an image copy is *
    *                      incorrect. Some expected records can be *
    *                      missing from the unloaded data and/or   *
    *                      the content of some unloaded records is *
    *                      incorrect. This can occur if all the    *
    *                      following conditions are fulfilled:     *
    *                      - the data is unloaded from an image    *
    *                        copy or a set of image copies         *
    *                        (COPYDDN option)                      *
    *                      - the input Image Copy is sorted by Db2 *
    *                        HPU before the unload as requested by *
    *                        the INLINE or FROM_COPYTOCOPY,        *
    *                        MERGE_IIC option or because Db2 HPU   *
    *                        determined that a sort was needed for *
    *                        the input image copy (COPYDDN ddname, *
    *                        CHECK option or COPYDDN LAST_IC/-     *
    *                        integer option)                       *
    *                      - the image copy or the set of image    *
    *                        copies contains several occurrence of *
    *                        the same tablespace page, one with    *
    *                        RBA set to 0 and other pages with     *
    *                        non-zero RBAs.                        *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Incorrout when unloading from non-reference image copy
    

Problem conclusion

  • Code has been changed to fix this problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH53039

  • 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-03-07

  • Closed date

    2023-03-23

  • Last modified date

    2023-04-03

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

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

    UI91097

Modules/Macros

  • INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R510 PSY UI91097

       UP23/03/29 P F303

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

Document Information

Modified date:
03 April 2023