PI98608: CM BATCH COMPARE ALTER ADD FK SELF-REFERENTIAL DELETE RULE NO ACTION GENERATES UNNECESSARY PACKAGE REBIND STATEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When processing a change involving an ALTER TABLE ADD FOREIGN
  KEY for a self-referential constraint, with Delete rule 'NO
  ACTION', Admin Tool Change Management or Object Comparison Tool
  generates rebind statements for all packages relating to the
  table, even though these packages are not invalidated by the
  change.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS Change Management batch function        *
  *                 and DB2 Object Comparison Tool for z/OS.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a self-referencing referential     *
  *                      constraint with Delete rule 'NO ACTION' *
  *                      is added to a table, CM Batch or        *
  *                      Object Compare may generate             *
  *                      unnecessary REBIND package              *
  *                      statements.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When processing a self-referential ALTER ADD FOREIGN
  KEY statement on a table, with Delete rule specified as
  'NO ACTION', CM Batch or Object Compare may generate
  REBIND statements for all packages that depend on the table.
  However, adding a constraint (self-referential or not)
  with Delete rule 'NO ACTION' (or 'RESTRICT', for that
  matter) does not invalidate a dependent package. There
  is no need, therefore, for these REBIND statements to be
  generated.
  

Problem conclusion

• Problems have been resolved.
  

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:

  UI57148 UI57149

Modules/Macros

•    ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI57148

     UP18/07/13 P F807

• RC10 PSY UI57149

     UP18/07/13 P F807

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.