PM34230: MISSING REBIND FOR PLANS/PACKAGES MARKED VALID 'A' CLARIFICATION OF HELP PANEL AND MANUAL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool does not produce a REBIND
  statement for a plan/package which has a status of VALID "A"
  in SYSIBM.SYSPLAN/SYSIBM.SYSPACKAGE after a change to the base
  table ( ALTER TABLE FOREIGN KEY for example ) even though the
  help panel GOC5H says:
  Run REBIND                   Whether to generate a job to rebind
  
                               plans and packages affected by
                               changes generated with Object
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool or      *
  *                 DB2 Object Comparison Tool for z/OS          *
  *                 who request Rebind processing as part of     *
  *                 the Compare, ALT or Change Management        *
  *                 functions.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When ALTER TABLE ... ADD FOREIGN KEY    *
  *                      with ON DELETE CASCADE or ON DELETE     *
  *                      SET NULL is performed, upon completion  *
  *                      of the change or job, the VALID field   *
  *                      of SYSIBM.SYSPACKAGE or SYSIBM.SYSPLAN  *
  *                      may contain an "A" or "N".  A REBIND    *
  *                      command is needed to rebind the         *
  *                      package or plan.                        *
  *                                                              *
  *                      The REBIND statement may not have       *
  *                      been performed by the products even     *
  *                      though the rebind process was           *
  *                      requested on panels GOC5 "Generate      *
  *                      Compare Jobs", ADBPALT "Build Analyze   *
  *                      and Apply Job" or, ADB2C11A "Generate   *
  *                      Analyze Job".                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a foreign key relationship is established with ON DELETE
  of CASCADE or SET NULL, packages and plans of the parent table
  will be invalidated.  This invalidation will continue upwards
  for parents of the parent table, and so on, where the ON
  DELETE rule of the relationship is also CASCADE or SET NULL.
  
  DB2 Object Comparison Tool produced REBIND statements only for
  the affected plans/packages of the child and/or parent table.
  

Problem conclusion

• DB2 Object Comparison Tool will continue to produce REBIND
  statements for packages/plans of only the child and/or parent
  tables.
  
  For DB2 R810 in new function mode and higher, the REBIND of
  other affected packages or plans will be handled during the
  running of the change by the batch restart program ADBTEP2 in
  conjunction with a new functional comment: "-#ADMIN AUTOREBIND
  ON".
  
  For DB2 R710 or DB2 R810 CM systems, the affected plans and
  packages may continue to be identified and rebound using the
  DB2 Administration Tool plan or package dialog.
  
  The AUTOREBIND ON functional comment instructs the product
  to perform additional steps when ALTER TABLE... ADD FOREIGN
  KEY statement with the ON DELETE rule is CASCADE or SET NULL
  is encountered.
  
  The AUTOREBIND ON functional comment will be added by the
  products when rebind processing is requested on panels
  GOC5, ADBPALT or ADB2C11A.
  
  When autorebind processing is active and a candidate
  ALTER TABLE statement is encountered, the affected plans
  and packages shall be identified. Upon ending the processing
  of all input statements, REBINDs will be performed for any
  affected plan or package whose VALID setting in
  SYSIBM.SYSPACKAGE or SYSIBM.SYSPLAN is not "Y".
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

•    ADBBIND  ADBBND01 ADBGAJOB ADBTEPR  ADBTEP2
  ADBTEP8  ADB5000  H0IH720J
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK67081

     UP11/04/27 P F104

• R720 PSY UK67082

     UP11/04/27 P F104

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.