PK10899: DURING OBJECT COMPARE PROCESSING WITH MASKING IN EFFECT, TRIGGER IS BEING REPORTED AS BEING CHANGED WHEN NO CHANGES EXIST.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Triggers are being reported as changed within Object Comparison
  Tool when masking is being used.
  TRIGGER with a OLD_TABLE AS / NEW_TABLE AS syntax is being
  affected here.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool and Users   *
  *                 of DB2 Object Comparison Tool are affected.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following items are addressed:      *
  *                      .* Identical triggers with TRANSIT      *
  *                         tables are not compared the same.    *
  *                      .* Trigger statement with TRANSIT       *
  *                         table generated by Admin has         *
  *                         incorrect syntax.                    *
  *                      .* Parser error on ALTER INDEX ......   *
  *                         ALTER partion-alteration when ALTER  *
  *                         word is ommited.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A  TRIGGER  with a OLD_TABLE AS / NEW_TABLE AS syntax was
  incorrectly  identified  as having  changes after MASKING
  was applied.
  

Problem conclusion

• During  OBJECT  COMPARE  processing  with MASKING in effect,
  TRIGGER  was  reported  as  being  changed  when  no  change
  existed. The reported problem has been fixed. Apply the fix.
  Note: fixed in parser function of DB2 Administration Tool.
  

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

•    ADB2PA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK10431

     UP05/12/31 P F512

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.