IBM Support

PH64829: NULL COPYID CHECK FOR AUTOREBIND

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The same COPYID check is used in ADBTEP2 Autorebind feature so
    it should be fixed to include packages with NULL COPYID.
    
    Also, need to add COPYID check in GEN to avoid unneeded REBINDs
    for old copies of packages.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Db2 Object Comparison Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides fixes to resolve     *
    *                      the ADBTEP2 and REBIND issues described *
    *                      in the problem summary.                 *
    ****************************************************************
    This APAR fixes the following issues:
    1. The ADBTEP2 automatic rebind feature does not rebind packages
    if they have a NULL value in the COPYID column in the SYSPACKDEP
    record.
    2. The ADBTEP2 automatic rebind feature does not rebind packages
    that are invalidated by creating new column masks or row
    permissions.
    3. ADBTEP2 with the AUTOREBIND option fails with ONCODE=3
    when processing the DROP MASK or the DROP PERMISSION statement.
    4. GEN and Object Compare generate an unnecessary REBIND command
    for packages that have old package copies with a dependency on
    the processed object.
    

Problem conclusion

  • The problems have been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH64829

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2025-01-14

  • Closed date

    2025-02-18

  • Last modified date

    2025-03-04

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

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

    UO02124

Modules/Macros

  • ADB2CDC  ADB2CM3  ADB2CME  ADB2CMF  ADB2CMO  ADB2CMP  ADB2CMR
    ADB2CMS  ADB2IGN  ADB2MSK  ADB2REC  ADB2REG  ADB2REH  ADB2REM
    ADB2REP  ADB2REU  ADB2RPT  ADBCCMM  ADBTEP2  ADBVFC   ADBVFCA
    ADBVFCF  ADBVVFG
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UO02124

       UP25/02/20 P F502

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 March 2025