PM10940: CHANGES REPORTED FOR A TRIGGER WHEN NONE EXIST IF CREATED BEFORE DB2 R810 AND SCHEMA OR NAME < 8 CHARACTERS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS (OC) incorrectly reports
  changes to a TRIGGER when the triggers were defined on DB2 R720
  or earlier, and when the trigger schema or name has a length
  less than 8 after removing blanks.
  This can result in duplicate CREATE TRIGGER DDL if using Admin
  functions, or for OC the error is that the same trigger is
  concatenated together which results in a difference when
  comparing the trigger.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration or               *
  *                 DB2 Object Comparison Tool for               *
  *                 z/OS who choose to generate or               *
  *                 compare triggers on DB2 v8 New               *
  *                 Function Mode or later, triggers             *
  *                 that were defined on DB2 v7                  *
  *                 or earlier, and when the trigger             *
  *                 schema or name has a length                  *
  *                 less than 8 after removing                   *
  *                 blanks.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Duplicate CREATE TRIGGER                *
  *                      DDL is generated when using             *
  *                      DB2 Admin functions.  In                *
  *                      DB2 Object Compare, the                 *
  *                      same trigger statement is               *
  *                      concatenated together, which            *
  *                      results in a difference when            *
  *                      comparing the trigger.                  *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Duplicate CREATE TRIGGER DDL is generated
  when using DB2 Admin functions.  In DB2 Object
  Compare, the same trigger statement is
  concatenated together, which results in a
  difference when comparing the trigger.
  

Problem conclusion

• The 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

•    ADB2REM  ADB2REP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK55960

     UP10/04/13 P F004

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.