PH70332: REBIND IMPROVEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• REBIND Improvements (REBINDs in the compare summary report,
  REBIND option for packages with statement level dependencies,
  Compare option to generate REBINDs for packages that can use new
  indexes)
  

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 enhances REBIND processing in *
  *                      Object Compare and AUTOREBIND           *
  *                      processing in ADBTEP2.                  *
  *                                                              *
  ****************************************************************
  A new Object Compare reporting option 'REBIND report' is added
  to enable the generation of a new 'PACKAGE REBIND REPORT'
  section with information about generated REBIND commands.
  
  New values are added for the 'Run REBIND' Compare option:
   - R (Recommended): REBIND will be generated for packages that
     will be invalidated by changes, packages that need to be
     rebound to apply ALTER changes (VALID='A' in SYSPACKAGE), and
     packages that depend on a table when a new index is added.
   - RP (Recommended package level): same as R, but REBIND is not
     generated for invalidated packages with statement-level
     dependencies.
   - MP (Mandatory package level): same as existing option M, but
     REBIND is not generated for invalidated packages with
     statement-level dependencies.
  
  New values are added for the 'AUTOREBIND' ADBTEP2 option:
   - M (Mandatory): only invalidated packages are automatically
     rebound (existing 'YES' option also rebinds VALID='A'
     packages).
   - MP (Mandatory package level): same as M, but invalidated
     packages with statement-level dependencies are not rebound.
   - YP (YES package level): same as YES, but invalidated packages
     with statement-level dependencies are not rebound.
   - AP (ALL package level): same as ALL, but invalidated packages
     with statement-level dependencies are not rebound.
  

Problem conclusion

Temporary fix

Comments

• The enhancement has been delivered.
  

APAR Information

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

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

  UO07080

Modules/Macros

• ADB2000  ADB2C11A ADB2CM1  ADB2CM2  ADB2CM3  ADB2CME  ADB2CMF
  ADB2CMO  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2REH
  ADB2UPA  ADBALT   ADBCCM   ADBCMBIV ADBEALT  ADBEMTAR ADBGAJOB
  ADBHALT  ADBHC11A ADBHUPA  ADBPALT  ADBSALT  ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UO07080

     UP26/03/14 P F603  

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.