PH62774: OBJECT COMPARE- TRIGGER CHANGE IS NOT RECOGNIZED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A trigger DDL is changed in the 'After update' clause from AFTER
  UPDATE ON . to AFTER UPDATE OF , ON .
  Compare does not recognize this change and does not generate a
  WSL.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare fails to recognize the   *
  *                      change in the trigger event UPDATE      *
  *                      clause.                                 *
  ****************************************************************
  When both the source and the target of Object Compare have
  UPDATE as the trigger event, and the source specifies a
  different column set in the trigger event clause, Object
  Compare fails to recognize this difference.
  After this APAR fix, the column changes in the trigger event
  UPDATE clause will be reported as a change as follows:
  
    (x) Trigger event UPDATE clause has been changed.
  
  Note: (x) can be (A) or (D) depending on whether the change is
  implemented by an ALTER TRIGGER statement or DROP and CREATE
  TRIGGER statements. For ALTER TRIGGER statements, (x) is
  (A). For other cases, (x) is (D).
  
  Keywords: TRIGGER UPDATE
  

Problem conclusion

• The problem has been fixed.
  

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:

  UI98715

Modules/Macros

• ADB2CMS  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RD10 PSY UI98715

     UP24/10/15 P F410

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.