PH63281: COMPARING BASIC TRIGGER TO ADVANCED TRIGGER CAUSES MISSING DROP/CREATE ON TRIGGER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When making a change to trigger using Object Compare Tool, if
  the Source and Target triggers are different types
  (Advanced/Basic), the change to trigger will be missing from
  Change File/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 a     *
  *                      change to a trigger when the source and *
  *                      target are separate types.              *
  ****************************************************************
  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:

  UI99191 UI99192

Modules/Macros

• ADB2CMS  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI99191

     UP24/11/27 P F411

• RD10 PSY UI99192

     UP24/12/03 P F411

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.