IBM Support

PH16591: DIFFICULT TROUBLESHOOTING IF REQUIRED BIND NOT RUN AFTER UPGRADETO DB2 V12

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • (HPU 4.3 only) After a Db2 subsystem or datasharing group has
    been upgraded to V12, if the INZBIND customization job has not
    been run as required, unpredicatble errors with no obvious
    relationship with the missing BIND can occur when running Db2
    HPU. This occurs only if Db2 HPU was bound before the upgrade of
    the Db2 subsystem or datasharing group.
    One of the possible errors is a failure with the INZI010E
    message.
    The lack of relationship between the issue and the root cause
    make troubleshooting difficult.
    Db2 HPU should detect and more clearly report such a situation.
    

Local fix

  • None but submitting the INZBIND customization job prevents the
    inconsistent behavior from occurring.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload         *
    *                 for z/OS                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: After a Db2 subsystem or datasharing    *
    *                      group has been upgraded to V12, if the  *
    *                      INZBIND customization job has not been  *
    *                      run as required, unpredicatble errors   *
    *                      with no obvious relationship with the   *
    *                      missing BIND can occur when running Db2 *
    *                      HPU. This occurs only if Db2 HPU was    *
    *                      bound before the upgrade of the Db2     *
    *                      subsystem or datasharing group.         *
    *                      One of the possible errors is a failure *
    *                      with the INZI010E message.              *
    *                      The lack of relationship between the    *
    *                      issue and the root cause make           *
    *                      troubleshooting difficult.              *
    *                      Db2 HPU should detect and more clearly  *
    *                      report such a situation.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Code has been changed to fix this problem.
    

Problem conclusion

  • Apply the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH16591

  • 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

    2019-09-09

  • Closed date

    2019-12-19

  • Last modified date

    2020-02-04

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

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

    UI67136

Modules/Macros

  •    INZQRYV9 INZSDBA  INZSDBE  INZSDBU  INZSETA
    INZSETE  INZSETU  INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R430 PSY UI67136

       UP20/01/03 P F001

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