IBM Support

PI74387: DB2 HPU MIGHT ABEND OR HAVE POOR PERFORMANCE IF THE LE OPTIONS ARE NOT SUITABLE TO DB2 HPU.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 HPU might ABEND or have poor performance if the LE options
    are not suitable to DB2 HPU. DB2 HPU should set its own LE
    options to prevent this issues from occurring.
    
    PB47673
    

Local fix

  • add the following DD card to the DB2 HPU step:
    //CEEOPTS DD *
    RPTOPTS(ON)
    RPTSTG(ON)
    ALL31(ON)
    HEAP(512K,128K,ANYWHERE,KEEP,4K,4K)
    STACK(128K,128K,ANYWHERE,KEEP,512K,128K)
    TRAP(ON,NOSPIE)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
    *                 z/OS.                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 HPU might stop in ABEND or have     *
    *                      low performance if the default LE       *
    *                      options are not suitable to DB2 HPU.    *
    *                      DB2 HPU should set its own LE options   *
    *                      to prevent this issues from occuring.   *
    *                      pb 47673                                *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    The inzmain and omsgsmsg module were changed.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI74387

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    430

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-01-04

  • Closed date

    2017-02-08

  • Last modified date

    2017-04-05

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

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

Modules/Macros

  •    INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R430 PSY UI44503

       UP17/03/01 P F702

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":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021