IBM Support

PH59775: INTERNAL APAR FOR HYBRID REBIND SOLUTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible in next release.

Error description

  • Internal APAR for Hybrid REBIND solution
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Db2 Object Comparison Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: The Batch Restart program (ADBTEP2) has *
    *                      been enhanced so that it can now        *
    *                      automatically rebind any packages that  *
    *                      are invalidated by an SQL statement.    *
    *                      Additionally, the new AUTOREBIND        *
    *                      function allows packages to be          *
    *                      automatically rebound when a new index  *
    *                      is created on the table so that the     *
    *                      access paths are refreshed for          *
    *                      dependent packages.                     *
    ****************************************************************
    The following enhancements are added by this APAR:
    
    The following new ADBTEP2 parameters are added:
    AUTOREBIND, REBIND_APREUSE, REBIND_EXPLAIN, REBIND_OWNER,
    REBIND_OWNERTYPE and REBIND_ADDITIONAL_OPTS.
    These parameters can be specified on the Batch Job
    Utility Parameters (ADB2UPA) panel to be used for WSL jobs
    generated by Object Compare, ALT, or Change Management.
    
    Additionally, the following new CM batch parameters are added:
    ADBTEP2_AUTOREBIND, ADBTEP2_AUTOREBIND_APREUSE,
    ADBTEP2_AUTOREBIND_EXPLAIN, ADBTEP2_AUTOREBIND_OWNER,
    ADBTEP2_AUTOREBIND_OWNERTYPE,
    ADBTEP2_AUTOREBIND_ADDITIONAL_OPTS.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH59775

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2024-02-13

  • Closed date

    2024-02-16

  • Last modified date

    2024-03-03

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

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

    UI95719

Modules/Macros

  • GOCMENU
    

Fix information

  • Fixed component name

    DB2 OBJECT COMP

  • Fixed component ID

    5697G6400

Applicable component levels

  • RD10 PSY UI95719

       UP24/02/20 P F402

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

Document Information

Modified date:
04 April 2024