IBM Support

PH51726: HANGING SITUATION AFTER ABENDSB37 ON SORTIN DATASET

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A Db2 HPU step hangs after an ABENDSB37 has occured for a SORTIN
    dataset (allocated under a TnnnIN ddname), i.e. a dataset used
    when a sort process uses the SORTIN method as reported by
    messages such as INZX063 SORT ACTIVATED VIA SORTIN).
    

Local fix

  • None but the issue can be avoided by preventing the ABENDSB37
    from occuring by either of te following ways:
    - changing the Db2 HPU settings to avoid the SORTIN method be
    used
    - ensuring the available storage space and the allocation
    parameters are suitable for the amount of data to be processed
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload         *
    *                 for z/OS                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: A Db2 HPU step hangs after an ABENDSB37 *
    *                      has occurred for a SORTIN dataset       *
    *                      (allocated under a TnnnIN ddname),      *
    *                      i.e. a dataset used when a sort process *
    *                      uses the SORTIN method as reported by   *
    *                      messages such as INZX063 SORT ACTIVATED *
    *                      VIA SORTIN).                            *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Hanging situation after ABENDSB37 on SORTIN dataset
    

Problem conclusion

  • Code has been changed to fix this problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH51726

  • 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-01-05

  • Closed date

    2023-02-13

  • Last modified date

    2023-03-01

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

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

Modules/Macros

  • INZCRXSM INZCRXSQ INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R510 PSY UI90505

       UP23/02/17 P F302

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:
01 March 2023