PM73422: DB2 OBJECT COMPARISON TOOL FOR Z/OS, TRIGGER TO BE DROPPED IS NOT IN THE COMPARISON REPORT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 OBJECT COMPARISON TOOL FOR Z/OS, TRIGGER TO BE DROPPED IS
  NOT IN THE COMPARISON REPORT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who compare DB2 Triggers.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare reports a trigger that   *
  *                      is not found on the source but does     *
  *                      not include the disposition of the      *
  *                      trigger.                                *
  *                                                              *
  *                      For example, when comparing a table     *
  *                      with triggers in source versus a        *
  *                      table with triggers in target, the      *
  *                      trigger not found in the source was     *
  *                      not included in the report:             *
  *                                                              *
  *                      Compare Trigger                         *
  *                      source(>schema<.>triggername1<)         *
  *                      and target(>schema<.>triggername2<)     *
  *                        Trigger >schema<.>triggername2<       *
  *                        will be dropped by dropping the       *
  *                        table                                 *
  *                        Trigger will be recreated             *
  *                                                              *
  *                      Trigger >schema<.>triggername3<         *
  *                      not found on source                     *
  *                                                              *
  *                      Trigger >schema<.>triggername3< is      *
  *                      to be dropped but it is not in the      *
  *                      OBJECT COMPARISON REPORT.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A TRIGGER reported in the OBJECT COMPARISON REPORT is not
  reported in the COMPARISON SUMMARY REPORT.  The index should
  be listed in the COMPARISON SUMMARY REPORT with a Result
  column showing 'Dropped'.
  

Problem conclusion

• Problem has 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:

Modules/Macros

•    ADB2CMP  ADB2CMS
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK82941

     UP12/10/30 P F210

• RA20 PSY UK82942

     UP12/10/30 P F210

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.