PH70373: 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:

  UO07081

Modules/Macros

• GOC5     GOC5H    GOC5RO   GOC5ROH  GOCCMP   GOCDB2   GOCGCMP
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RD10 PSY UO07081

     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.